Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Expd
@kaggle.rprkh15_sp500_stock_prices.expd

  • 407.61 KB
  • 9525 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Sep 26 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.14204746362512240.13393022119998930.1339302211999893600000
Thu Sep 27 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.14001830286196570.13595928251743310.1359592825174331240000
Fri Sep 28 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.1379884267376340.13190108537673950.1319010853767395201600
Mon Oct 01 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.13595932144354840.1298719793558120.129871979355812240000
Tue Oct 02 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.1319010746468410.12784284353256220.127842843532562224000
Wed Oct 03 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.12784284353256220.12784284353256220.12784284353256220.1278428435325622
Thu Oct 04 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.12987199655247590.12378386408090590.1237838640809059321600
Fri Oct 05 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.12378386408090590.12378386408090590.12378386408090590.1237838640809059
Mon Oct 08 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.12784290639815620.12175477296113960.121754772961139648000
Tue Oct 09 1984 00:00:00 GMT+0000 (Coordinated Universal Time)0.12784290639815620.12175477296113960.1217547729611396192000

CREATE TABLE expd (
  "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.