Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dhr
@kaggle.rprkh15_sp500_stock_prices.dhr

  • 451.05 KB
  • 10977 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Dec 29 1978 00:00:00 GMT+0000 (Coordinated Universal Time)0.07913422584533690.07367672877390050.0791342258453369654224
Tue Jan 02 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.07913422584533690.07913422584533690.07913422584533690.0791342258453369
Wed Jan 03 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.08459175577474220.08186346292495720.0818634629249572168832
Thu Jan 04 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.08459176123142240.0818634682056460.0845917612314224177274
Fri Jan 05 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.09004925936460490.08459175387382540.0900492593646049333443
Mon Jan 08 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.09004925936460490.08732096657612920.0900492593646049299677
Tue Jan 09 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.09004925367420910.08459174852830040.0873209610581398818835
Wed Jan 10 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.09004925367420910.08732096105813980.0873209610581398502275
Thu Jan 11 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.08732097417110690.08459176123142240.0845917612314224143507
Fri Jan 12 1979 00:00:00 GMT+0000 (Coordinated Universal Time)0.08732096105813980.08459174852830040.0873209610581398582470

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