S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Oct 19 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.988655788766662	8.988655788766662	8.007191243638891	8.041202545166016	2721233
Tue Oct 20 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	7.89544291588075	8.225836775458063	7.89544291588075	8.196683883666992	1220907
Wed Oct 21 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.381313401454968	8.429901541253939	7.968321786997945	8.007190704345703	135236
Thu Oct 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.1189418978511	8.284138377426217	7.890581237744357	8.235551834106445	189261
Fri Oct 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.381313132452835	8.381313132452835	8.186963768477518	8.259844779968262	103061
Mon Oct 26 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.313293268131183	8.313293268131183	7.924594449720095	7.978040218353271	885743
Tue Oct 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	8.046062294290893	8.138377779164179	7.57962326493316	7.642787456512451	1094274
Wed Oct 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	7.725384003744016	7.944027834746115	7.698661125734034	7.9100165367126465	509801
Thu Oct 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	7.77883261240944	7.905159413060853	7.5553311044120495	7.749680519104004	499650
Fri Oct 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	7.72538345763431	7.822558929680147	7.1520538330078125	7.1520538330078125	4214161


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