Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tyl
@kaggle.rprkh15_sp500_stock_prices.tyl

  • 306.92 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.8976614159681690.84824885404353710.856484532356262253400
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.84001352937890550.80707194800707840.831778228282928565400
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.84001352937890550.80707194800707840.831778228282928528200
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.84001362868505540.80707204341888430.807072043418884321000
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.83177833966530560.79060107469558720.790601074695587223400
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.7988363768943430.79060107469558720.790601074695587224000
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.8070719088232770.72471739391018890.732953071594238352800
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.7658947368879340.74118845505283940.757659435272216817400
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.76589469819518830.72471743822097780.724717438220977830000
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.75765943527221680.72471747483346190.757659435272216821000

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