Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Hst
@kaggle.rprkh15_sp500_stock_prices.hst

  • 485.17 KB
  • 10671 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Mon Mar 17 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.21538177373587660.21115857272978640.2139739990234375110634
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.22101259231567380.21256625316875650.2210125923156738260821
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.22805126110375690.21960492038012210.2252358347177505106048
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.22664350560215340.22101259231567380.2210125923156738237891
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.22382806479069390.21819715188034180.219604864716529895157
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.21819716691970820.21397396655445760.2181971669197082329609
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.21538169682025910.21538169682025910.215381696820259184265
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.2167894094643720.21538169682025910.215381696820259197449
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.21538183810917730.20693549513816830.20693549513816831218119
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)0.21819716691970820.20975082775481130.2181971669197082134136

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