Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dal
@kaggle.rprkh15_sp500_stock_prices.dal

  • 192.19 KB
  • 3825 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu May 03 2007 00:00:00 GMT+0000 (Coordinated Universal Time)19.31936913061076319.49701917960529618.25347222503642518.404474258422858052800
Fri May 04 2007 00:00:00 GMT+0000 (Coordinated Universal Time)18.8752430551325618.9640680671724218.38670803020760418.635416030883795437300
Mon May 07 2007 00:00:00 GMT+0000 (Coordinated Universal Time)18.8308308127367218.9107731516759617.9425841082528418.084703445434572646300
Tue May 08 2007 00:00:00 GMT+0000 (Coordinated Universal Time)17.76493710073084717.76493710073084717.14316362452669717.43628501892094166100
Wed May 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)17.5428727907429517.94258449403328717.43628243846680417.578403472900397541100
Thu May 10 2007 00:00:00 GMT+0000 (Coordinated Universal Time)17.5784050247173117.7560533685987417.36522430134547817.4984626770019533170600
Fri May 11 2007 00:00:00 GMT+0000 (Coordinated Universal Time)17.507346705127317.5872890667741816.97439988641026817.1431655883789063539400
Mon May 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)17.0099207419581117.2230997062468516.65462246814354316.7789764404296881924800
Tue May 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)16.56579999509350316.7434500061116916.121676661744116.166090011596683438700
Wed May 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)16.0417337527152516.41479740715960416.0062047682994116.2904434204101562607600

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

Share link

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