Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Hes
@kaggle.rprkh15_sp500_stock_prices.hes

  • 508.54 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)4.515468546434724.3166005900733514.36339282989502747600
Tue Mar 18 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.550562911548744.2464120105323584.5154685974121091204800
Wed Mar 19 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.6324483294819684.5271654129028324.527165412902832745200
Thu Mar 20 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.5856552496160954.3984852978789454.421881675720215430800
Fri Mar 21 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.4686726574276574.3399939537048344.339993953704834453000
Mon Mar 24 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.31660002641650654.0475434777073774.082637786865234810000
Tue Mar 25 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.1762206878929443.93056064742865363.97735285758972172117400
Wed Mar 26 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.0475437506987743.8954685792567213.9188649654388423816600
Thu Mar 27 1980 00:00:00 GMT+0000 (Coordinated Universal Time)3.8720722709094873.5211291486066123.8369779586791991286400
Fri Mar 28 1980 00:00:00 GMT+0000 (Coordinated Universal Time)4.1177297193136313.89546606810094884.04754114151001837600

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