Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Bk
@kaggle.rprkh15_sp500_stock_prices.bk

  • 535.33 KB
  • 12407 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu May 03 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.55618184274050090.56033259630203250.55618184274050090.560332596302032576981
Fri May 04 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56033259630203250.56033259630203250.55618184274050090.560332596302032556604
Mon May 07 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56033259630203250.56033259630203250.55203149248234780.560332596302032561132
Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.55618202686309810.55618202686309810.55618202686309810.556182026863098122642
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.55618207242221360.56448358297348020.55203172045012560.5644835829734802378115
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56448358297348020.56448358297348020.56448358297348020.564483582973480220377
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56448358297348020.56448358297348020.56033282769784690.564483582973480215849
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56033259630203250.56033259630203250.55618184274050090.560332596302032515849
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.56033278179872640.56033278179872640.55203167523098220.556182026863098172453
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.55618202686309810.56448353673435450.55618202686309810.556182026863098154340

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