S&P 500 Stock Data

Historical stock data for all current S&P 500 companies

@kaggle.camnugent_sandp500

Table List

1 table(10.08 MB)

All Stocks 5yr

@kaggle.camnugent_sandp500.all_stocks_5yr

10.08 MB
619040 rows
7 columns

date Date	open Open	high High	low Low	close Close	volume Volume	name Name
Fri Feb 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	15.07	15.12	14.63	14.75	8407500	AAL
Mon Feb 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.89	15.01	14.26	14.46	8882000	AAL
Tue Feb 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.45	14.51	14.1	14.27	8126000	AAL
Wed Feb 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.3	14.94	14.25	14.66	10259500	AAL
Thu Feb 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.94	14.96	13.16	13.99	31879900	AAL
Fri Feb 15 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.93	14.61	13.93	14.5	15628000	AAL
Tue Feb 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.33	14.56	14.08	14.26	11354400	AAL
Wed Feb 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.17	14.26	13.15	13.33	14725200	AAL
Thu Feb 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.62	13.95	12.9	13.37	11922100	AAL
Fri Feb 22 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.57	13.6	13.21	13.57	6071400	AAL


CREATE TABLE all_stocks_5yr (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "name" VARCHAR
);