Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Mck
@kaggle.rprkh15_sp500_stock_prices.mck

  • 350.64 KB
  • 6965 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Nov 10 1994 00:00:00 GMT+0000 (Coordinated Universal Time)13.00548446539676613.00548446539676612.81137275695800812.811372756958008728000
Fri Nov 11 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.76284694671630912.81137488187492612.76284694671630912.762846946716309151800
Mon Nov 14 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.76284716511500912.76284716511500912.71431922912597712.71431922912597736800
Tue Nov 15 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.71431678625253512.71431678625253512.61726093292236312.617260932922363114800
Wed Nov 16 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.6657888595874512.71431678625253512.61726093292236312.617260932922363751200
Thu Nov 17 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.66579579754685812.66579579754685812.5202119378049412.568739891052246603600
Fri Nov 18 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.56873989105224612.61726784429955112.47168398455763412.568739891052246543600
Mon Nov 21 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.6172654747506212.66579341888427612.6172654747506212.665793418884276266800
Tue Nov 22 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.71432177973728512.71432177973728512.37462615966796912.374626159667969649800
Wed Nov 23 1994 00:00:00 GMT+0000 (Coordinated Universal Time)12.27756999787830212.27756999787830212.03493027460007512.229042053222656796400

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