Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Etn
@kaggle.rprkh15_sp500_stock_prices.etn

  • 586.74 KB
  • 12637 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.36886523663172220.36399901592450820.366918802261352582978
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.36594520220820710.36594520220820710.36205214397167640.3630254566669464120318
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.3610791681770590.3610791681770590.35523948159253630.3562127947807312107871
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.35621263817191840.35815926369247470.35231957967536780.3542661666870117327763
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.3532930160434620.3532930160434620.35134658217430110.351346582174301143563
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.35134658217430110.3532930160434620.35134658217430110.351346582174301187127
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.35134657456711250.35134657456711250.34842678904533380.3484267890453338497868
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.3484266812592220.34939984010828940.3445336222648620.344533622264862109946
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.34453382339723430.35037335753440850.34064076213017830.3503733575344085103722
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)0.35037324516138810.35231971740722650.34842677291554970.352319717407226535266

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