Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mkc
@kaggle.rprkh15_sp500_stock_prices.mkc

  • 475.96 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.41211393475532530.41211393475532530.41211393475532530.4121139347553253236800
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.41586047410964960.41586047410964960.41586047410964960.415860474109649670400
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.41960686445236210.41960686445236210.41960686445236210.41960686445236270400
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.41211393475532530.41211393475532530.41211393475532530.4121139347553253179200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.4083677828311920.4083677828311920.4083677828311920.40836778283119225600
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.4008745253086090.4008745253086090.4008745253086090.400874525308609166400
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.38401487469673150.38401487469673150.38401487469673150.3840148746967315358400
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.37464874982833860.37464874982833860.37464874982833860.3746487498283386288000
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.37464874982833860.37464874982833860.37464874982833860.374648749828338670400
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.38588851690292360.38588851690292360.38588851690292360.3858885169029236377600

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