Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Zbh
@kaggle.rprkh15_sp500_stock_prices.zbh

  • 267.47 KB
  • 5274 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jul 25 2001 00:00:00 GMT+0000 (Coordinated Universal Time)26.20420640419966727.49220913686721726.20420640419966726.4351577758789032512582
Thu Jul 26 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.6712396525967425.6712396525967424.8717888057628424.9606170654296882755662
Fri Jul 27 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.04944954509741725.7689547304271225.04944954509741725.227106094360351440146
Mon Jul 30 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.22710826194990525.3603489402613725.22710826194990525.28040313720703789907
Tue Jul 31 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.2803928378020425.4491668543605625.25374541102982625.404752731323241003838
Wed Aug 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.7600688053745826.5151055485524525.7600688053745826.204208374023441919611
Thu Aug 02 2001 00:00:00 GMT+0000 (Coordinated Universal Time)26.1864430561119526.38186454643192725.31593057248263525.44917297363281808550
Fri Aug 03 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.22710298701114725.2715153737722124.7829634136448924.8717899322509771240635
Mon Aug 06 2001 00:00:00 GMT+0000 (Coordinated Universal Time)24.87179395417265625.0494505102808924.24999949796229324.658607482910161612465
Tue Aug 07 2001 00:00:00 GMT+0000 (Coordinated Universal Time)25.3159267694986927.0924831258714425.04944375231372826.5950469970703128050274

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