Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dhi
@kaggle.rprkh15_sp500_stock_prices.dhi

  • 363.93 KB
  • 7581 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Jun 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.14348983764648441.16947841368827321.14348983764648441.143489837646484414561059
Mon Jun 08 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.14348983764648441.16947841368827321.14348983764648441.14348983764648441306967
Tue Jun 09 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.14349030280513421.14349030280513421.09151387214660641.09151387214660641942140
Wed Jun 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.09151387214660641.1304963395288731.09151387214660641.0915138721466064666466
Thu Jun 11 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.091513638223271.091513638223271.0395364761352541.0395364761352541383534
Fri Jun 12 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.0395364761352541.07851901767077481.0395364761352541.039536476135254502679
Mon Jun 15 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.03953667608685321.07851922512054441.03953667608685321.0785192251205444209727
Tue Jun 16 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.05253100395202641.0915135420528991.0395363845444531.0525310039520264340890
Wed Jun 17 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.05253100395202641.0915135420528991.05253100395202641.0525310039520264523985
Thu Jun 18 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.0395364761352541.091513638223271.0395364761352541.039536476135254323579

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