Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Dlr
@kaggle.rprkh15_sp500_stock_prices.dlr

  • 228.73 KB
  • 4455 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Oct 29 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501963615417485.8550716367600065.8501963615417485.8501963615417485951800
Mon Nov 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501963615417485.8550716367600065.8501963615417485.850196361541748764400
Tue Nov 02 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501963615417485.8550716367600065.8501963615417485.850196361541748950100
Wed Nov 03 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8599431392819425.9476957120553415.8550678672024385.923319816589356433600
Thu Nov 04 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9379488855432735.9379488855432735.8745717085872995.879446983337402311200
Fri Nov 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8745696112655315.8989455113816445.8501937111494175.889194965362549391800
Mon Nov 08 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.9135720067457895.9135720067457895.8501948401853095.85507011413574291100
Tue Nov 09 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501948401853095.879446018956195.8501948401853095.85507011413574297600
Wed Nov 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501948401853095.86969547105532555.8501948401853095.855070114135742177500
Thu Nov 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)5.8501918932291035.8599424362182615.8501918932291035.85994243621826292700

CREATE TABLE dlr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "dividends" DOUBLE,
  "stock_splits" BIGINT
);

Share link

Anyone who has the link will be able to view this.