Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Wm
@kaggle.rprkh15_sp500_stock_prices.wm

  • 376.72 KB
  • 8581 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Jun 22 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.79256666028821782.7190780639648442.71907806396484418200
Thu Jun 23 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.64558859432444842.49861145019531252.498611450195312551100
Fri Jun 24 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.57210040092468262.57210040092468262.572100400924682611800
Mon Jun 27 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.57210002225988042.49861145019531252.498611450195312513200
Tue Jun 28 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.49861089885234832.3516337871551522.35163378715515216200
Wed Jun 29 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.4986108144124352.42512226104736372.42512226104736378900
Thu Jun 30 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.6455889838082452.57210040092468262.572100400924682647300
Fri Jul 01 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.8660551309585572.7925665378570562.79256653785705629100
Tue Jul 05 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.8660552566115922.7190780639648442.71907806396484414000
Wed Jul 06 1988 00:00:00 GMT+0000 (Coordinated Universal Time)2.71907720963160232.64558863639831542.645588636398315420000

CREATE TABLE wm (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Share link

Anyone who has the link will be able to view this.