Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Syy
@kaggle.rprkh15_sp500_stock_prices.syy

  • 500.67 KB
  • 12404 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue May 08 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.07797192782163620.07797192782163620.07797192782163620.077971927821636228800
Wed May 09 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.07797192782163620.07797192782163620.07797192782163620.077971927821636228800
Thu May 10 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08263353887176730.08771883696317670.08263353887176730.0877188369631767172800
Fri May 11 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08771883696317670.08771883696317670.08771883696317670.0877188369631767331200
Mon May 14 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08771883696317670.08771883696317670.08771883696317670.0877188369631767
Tue May 15 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08771883696317670.08771883696317670.08771883696317670.0877188369631767316800
Wed May 16 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08771881446996970.08771881446996970.08263351768255230.082633517682552357600
Thu May 17 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.08263351768255230.08263351768255230.08263351768255230.082633517682552386400
Fri May 18 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.07797192782163620.07797192782163620.07797192782163620.0779719278216362201600
Mon May 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)0.07797193068846040.07797193068846040.0728871226310730.072887122631073100800

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