Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dgx
@kaggle.rprkh15_sp500_stock_prices.dgx

  • 316.59 KB
  • 6434 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Dec 17 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.8640262569699972.8640262569699972.6730911731719972.6730911731719971272400
Wed Dec 18 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.67309282537092232.74469352605050082.5298914240117662.72082662582397461186800
Thu Dec 19 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.7446927983536682.84016037394857832.7446927983536682.792426586151123528800
Fri Dec 20 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.7685594558715822.8401601314544682.7685594558715822.840160131454468233200
Mon Dec 23 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.8640258507650412.9356264970341672.8401589686753322.91175961494445857200
Tue Dec 24 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.9356272296905522.9833610057830812.9356272296905522.98336100578308114000
Thu Dec 26 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.98336026121358433.0072271433032932.91175961494445852.91175961494445822000
Fri Dec 27 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.91175961494445852.91175961494445852.91175961494445852.911759614944458800
Mon Dec 30 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.9356274565389332.9356274565389332.88789367675781252.887893676757812528400
Tue Dec 31 1996 00:00:00 GMT+0000 (Coordinated Universal Time)2.8640267868672522.88789367675781252.8640267868672522.887893676757812515600

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