New York Stock Exchange

S&P 500 companies historical prices with fundamental data

@kaggle.dgawlik_nyse

Table List

4 tables(26.49 MB)

Fundamentals

Prices Split Adjusted

Prices

Securities

Prices Split Adjusted

@kaggle.dgawlik_nyse.prices_split_adjusted

13.31 MB
851264 rows
7 columns

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


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