Baselight
Sign In

S&P500 Stock Prices

Historical stock price data of all S&P500 companies

@kaggle.rprkh15_sp500_stock_prices

Hwm
@kaggle.rprkh15_sp500_stock_prices.hwm

  • 75.9 KB
  • 1432 rows
  • 8 columns
date

Date

open

Open

high

High

low

Low

close

Close

volume

Volume

dividends

Dividends

stock_splits

Stock Splits

Tue Nov 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)21.478093394089621.8643896734425518.10765536347542318.27183151245117
Wed Nov 02 2016 00:00:00 GMT+0000 (Coordinated Universal Time)18.2138934974544218.32012385782110517.0260295165721117.325410842895508
Thu Nov 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)17.1226050354442417.43164217742978616.82322553439657416.890827178955078
Fri Nov 04 2016 00:00:00 GMT+0000 (Coordinated Universal Time)16.99705485254758517.19020209375463516.91013794930225317.07431411743164
Mon Nov 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)17.2867789777631317.38335353245583516.68802005427991416.74596405029297
Tue Nov 08 2016 00:00:00 GMT+0000 (Coordinated Universal Time)16.85274689630347217.03719382337687816.71683639281887316.9012851715087965374000.09
Wed Nov 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)16.4547314601328417.18281689019859516.2605746048018417.017784118652344
Thu Nov 10 2016 00:00:00 GMT+0000 (Coordinated Universal Time)17.03719622612118217.9885624782178817.03719622612118217.910900115966797
Fri Nov 11 2016 00:00:00 GMT+0000 (Coordinated Universal Time)17.8914802885159618.38657843778812817.77498584390418.3089160919189455358700
Mon Nov 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)18.3865831552058218.56132394114854718.2797967078815218.53219985961914

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