New York Stock Exchange

S&P 500 companies historical prices with fundamental data

@kaggle.dgawlik_nyse

Prices

@kaggle.dgawlik_nyse.prices

date Date	symbol Symbol	open Open	close Close	low Low	high High	volume Volume
2016-01-05 00:00:00	WLTW	123.43	125.839996	122.309998	126.25	2163600
2016-01-06 00:00:00	WLTW	125.239998	119.980003	119.940002	125.540001	2386400
2016-01-07 00:00:00	WLTW	116.379997	114.949997	114.93	119.739998	2489500
2016-01-08 00:00:00	WLTW	115.480003	116.620003	113.5	117.440002	2006300
2016-01-11 00:00:00	WLTW	117.010002	114.970001	114.089996	117.330002	1408600
2016-01-12 00:00:00	WLTW	115.510002	115.550003	114.5	116.059998	1098000
2016-01-13 00:00:00	WLTW	116.459999	112.849998	112.589996	117.07	949600
2016-01-14 00:00:00	WLTW	113.510002	114.379997	110.050003	115.029999	785300
2016-01-15 00:00:00	WLTW	113.330002	112.529999	111.919998	114.879997	1093700
2016-01-19 00:00:00	WLTW	113.660004	110.379997	109.870003	115.870003	1523500


CREATE TABLE prices (
  "date" VARCHAR,
  "symbol" VARCHAR,
  "open" DOUBLE,
  "close" DOUBLE,
  "low" DOUBLE,
  "high" DOUBLE,
  "volume" DOUBLE
);