Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Hal
@kaggle.rprkh15_sp500_stock_prices.hal

  • 621.61 KB
  • 12637 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Thu Jun 01 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.35441851615905761.33567830072307331.3544185161590576158655
Fri Jun 02 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.35441883451634771.3799739624505511.345900403982791.3646409511566162705134
Mon Jun 05 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.3596930948915271.3596930948915271.31186461581845861.3152807950973512845720.010443
Tue Jun 06 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.31528103280155521.3255301468313381.30844859096028631.3118648529052734203985
Wed Jun 07 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.31186380502833291.31527998219587581.30503128659596661.306739211082458585623
Thu Jun 08 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.30674011124487951.3152808882417061.3016155958175661.301615595817566191394
Fri Jun 09 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.29820009421208771.29820009421208771.27428600308014281.2947838306427002292127
Mon Jun 12 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.29478383064270021.310157139778061.29478383064270021.2947838306427002128435
Tue Jun 13 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.29478279902344881.30161532071840621.28111750948749671.2879502773284912720244
Wed Jun 14 1972 00:00:00 GMT+0000 (Coordinated Universal Time)1.28795062985923181.30161567698946821.28624237589490021.2981994152069092594327

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