Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Cmcsa
@kaggle.rprkh15_sp500_stock_prices.cmcsa

  • 479.55 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.07246356036958670.06938026100397110.0693802610039711138396
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07246356036958670.06938026100397110.0693802610039711530518
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07169326706741860.06860925257205960.0686092525720596738113
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07708959158794290.07400558143854140.07400558143854141360895
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07940188424010820.0763185843825340.076318584382534461320
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07863086005638160.07554756104946130.0755475610494613322924
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07554758199005460.0724635720252990.072463572025299738113
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.07554758199005460.0724635720252990.07246357202529923066
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.06167167284477140.05858766287565230.05858766287565232168205
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.06552598141448760.06244197115302080.0624419711530208553584

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