Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mco
@kaggle.rprkh15_sp500_stock_prices.mco

  • 323.69 KB
  • 6973 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Oct 31 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.5628013288168086.6629967689514166.5628013288168086.6629967689514161984200
Tue Nov 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.66299942767981356.66299942767981356.5628039475643286.612901687622072176400
Wed Nov 02 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.61290004235187656.61290004235187656.5628023147583016.5628023147583012348200
Thu Nov 03 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.5628023147583016.61290004235187656.5127045871647266.5628023147583012060800
Fri Nov 04 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.56280450087327256.6129022451547486.5127067565917976.5127067565917972663800
Mon Nov 07 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.4626088142395026.4626088142395026.41251107149345946.4626088142395021049400
Tue Nov 08 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.4626082011631566.4626082011631566.3123149871826186.3123149871826175761000
Wed Nov 09 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.3624145500361926.4626100547611716.3624145500361926.4125123023986822480000
Thu Nov 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.41251107149345946.4626088142395026.41251107149345946.4626088142395021956000
Fri Nov 11 1994 00:00:00 GMT+0000 (Coordinated Universal Time)6.4626100547611716.4626100547611716.4125123023986826.4125123023986821300200

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