Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Ctas
@kaggle.rprkh15_sp500_stock_prices.ctas

  • 420.4 KB
  • 9804 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Aug 19 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.69461931954200960.67973488569259640.67973488569259641996200
Mon Aug 22 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.69461938141584270.68469619750976560.68469619750976561621800
Tue Aug 23 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.68965817273214450.68469619750976560.68469619750976561972800
Wed Aug 24 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.70454259998593270.68965816497802730.6896581649780273819000
Thu Aug 25 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.71446586301572670.69958138465881350.6995813846588135347400
Fri Aug 26 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.72935033396278470.70950460433959960.7095046043395996549000
Mon Aug 29 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.74423540832778110.72438895702362060.7243889570236206552600
Tue Aug 30 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.7740044660022250.7591199874877930.759119987487793777600
Wed Aug 31 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.7740044660022250.7591199874877930.7591199874877931432800
Thu Sep 01 1983 00:00:00 GMT+0000 (Coordinated Universal Time)0.76408133374227450.75415891408920290.7541589140892029271800

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