Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Whr
@kaggle.rprkh15_sp500_stock_prices.whr

  • 535.02 KB
  • 12457 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Feb 21 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.4718019217252735.2852632198482755.30598974227905369200
Thu Feb 22 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.3059907091464925.2438111305236825.24381113052368279600
Fri Feb 23 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.2852647226364884.9950933260995835.057272911071777158000
Mon Feb 26 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0572729110717774.9743667977755185.05727291107177750200
Tue Feb 27 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0987255152534044.9329133033752444.93291330337524417800
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0987256578177464.9743664954319485.015819549560547103800
Thu Mar 01 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0572727580129374.9743666472258395.03654623031616281000
Fri Mar 02 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.0365462303161624.9329135918322915.03654623031616216600
Mon Mar 05 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.1194524960439715.0158198544236485.05727291107177710200
Tue Mar 06 1973 00:00:00 GMT+0000 (Coordinated Universal Time)5.3474410124651095.0987228258388255.26453495025634847000

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