Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ea
@kaggle.rprkh15_sp500_stock_prices.ea

  • 390.79 KB
  • 8266 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Sep 20 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.52649194905252160.51100689172744750.511006891727447515396800
Thu Sep 21 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.50326478426745780.49552178382873540.49552178382873536224000
Fri Sep 22 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.50326478426745780.49552178382873540.49552178382873532041600
Mon Sep 25 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.47229468716403180.46455165743827820.46455165743827823072000
Tue Sep 26 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.47229468716403180.46455165743827820.4645516574382782888000
Wed Sep 27 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.47229468716403180.46455165743827820.4645516574382782523200
Thu Sep 28 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.46455166463194220.44906660914421080.4490666091442108574400
Fri Sep 29 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.46455166463194220.44906660914421080.4490666091442108240000
Mon Oct 02 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.47229468716403180.46455165743827820.46455165743827821244800
Tue Oct 03 1989 00:00:00 GMT+0000 (Coordinated Universal Time)0.51100683957338330.46455167233943940.4955217838287353883200

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