Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Kmi
@kaggle.rprkh15_sp500_stock_prices.kmi

  • 149.09 KB
  • 2872 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Fri Feb 11 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.9399786623058819.2028671292063218.37237633592728518.55161857604980550610600
Mon Feb 14 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.5516142980193318.70098317687486418.34249877929687518.3424987792968756275900
Tue Feb 15 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.46199177638216318.6113606437308818.3604209010012818.485891342163094337800
Wed Feb 16 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.55160556341226718.7846216796404818.31859058677762418.354438781738284627100
Thu Feb 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.33054682035047718.5755116614380518.2289759491975318.252874374389653290700
Fri Feb 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.33054709888443818.74877923265035718.16325356162167618.742805480957032583800
Tue Feb 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.6053784256500418.7786467905481118.3484638926459118.354438781738282454300
Wed Feb 23 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.3783508545244818.4619970795970818.07363814085299218.175209045410162671200
Thu Feb 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.25287337260825618.31262114170034718.10350451967498518.199100494384771698000
Fri Feb 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)18.2409318817815718.37237611364145518.1035116171162818.223007202148442225900

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