Baselight

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Tdg
@kaggle.rprkh15_sp500_stock_prices.tdg

  • 204.95 KB
  • 4110 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Wed Mar 15 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.46686205286952810.79026394333770410.24834719442605610.5324163436889657251200
Thu Mar 16 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.53241819669838210.64167564514220610.44064150655011710.60671329498291649100
Fri Mar 17 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.59797109318225410.9781873300993610.55426795288850910.930113792419434287000
Mon Mar 20 2006 00:00:00 GMT+0000 (Coordinated Universal Time)11.00003825002227811.19233156309312310.816485731538310.882040023803713282800
Tue Mar 21 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.87766932570828410.87766932570828410.48871314659707810.576119422912598274700
Wed Mar 22 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.51056598333250310.61982342945266710.48871482753573610.558639526367188103000
Thu Mar 23 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.5280459464919310.57611948209126310.48434280808962910.532416343688965106200
Fri Mar 24 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.61982332479579410.9213741065147910.5936017713844510.707229614257812101300
Mon Mar 27 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.7727813171003811.25351412609370210.685375882281210.816484451293944111700
Tue Mar 28 2006 00:00:00 GMT+0000 (Coordinated Universal Time)10.80774613246755110.86456046999875410.7290806396201310.794635772705078115400

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