Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Slb
@kaggle.rprkh15_sp500_stock_prices.slb

  • 511.87 KB
  • 10218 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Dec 31 1981 00:00:00 GMT+0000 (Coordinated Universal Time)5.3774526092563435.4015667465175835.3533384719951045.389509677886963449200
Mon Jan 04 1982 00:00:00 GMT+0000 (Coordinated Universal Time)5.3051090240478525.3895084857940675.2086524963378915.280994892120361630400
Tue Jan 05 1982 00:00:00 GMT+0000 (Coordinated Universal Time)5.1121993706776545.1965988885897865.0157427787780765.0157427787780761076800
Wed Jan 06 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.9675102233886725.0036814143356774.9192819687926654.9675102233886721560400
Thu Jan 07 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.9072277687563764.9916272635507114.822828273962044.871056556701661303600
Fri Jan 08 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.94339871814606554.9795699282788414.895170437969034.931341648101807991200
Mon Jan 11 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.858998071118664.9916258100325694.7263703322047514.7504844665527341479600
Tue Jan 12 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.8228280338240274.8951704543313874.7384285432321054.8831133842468261089600
Wed Jan 13 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.8831122029911395.0398540761735714.7143132626408284.7745985984802251231200
Thu Jan 14 1982 00:00:00 GMT+0000 (Coordinated Universal Time)4.83488510390858654.8831133842468264.7745997534857864.8831133842468261068400

CREATE TABLE slb (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" DOUBLE
);

Share link

Anyone who has the link will be able to view this.