Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Rop
@kaggle.rprkh15_sp500_stock_prices.rop

  • 364.1 KB
  • 7659 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Feb 13 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.631995630628281.70849542581398061.631995630628281.670245528221130418506400
Fri Feb 14 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.68299581607182841.86149537232187031.68299581607182841.83599543571472173128000
Tue Feb 18 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.81049509301330081.8614949547883241.68299543857574461.68299543857574462584800
Wed Feb 19 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.70849597454071041.75949585437774661.65749609470367431.75949585437774662454400
Thu Feb 20 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.7339951152532871.8614947560807351.7339951152532871.8104948997497561304000
Fri Feb 21 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.81049515449837471.8614950180053711.81049515449837471.861495018005371616800
Mon Feb 24 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.81049561983830241.8869954347610481.81049561983830241.8869954347610476772800
Tue Feb 25 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.84874505212862241.88699494975886921.8359950862518731.861495018005371517600
Wed Feb 26 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.88699437777201331.91249430179595971.8359945297241211.9124943017959597851200
Thu Feb 27 1992 00:00:00 GMT+0000 (Coordinated Universal Time)1.86149584008501681.98899555515933321.86149584008501681.9634956121444704555200

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