S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Oct 20 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	27.899999618530277	33	27.31999969482422	28.25	1333600
Tue Oct 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.489999771118164	29.489999771118164	28.299999237060547	28.309999465942383	697700
Wed Oct 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.46999931335449	28.90999984741211	28	28.75	768800
Thu Oct 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	28.75	29.88999938964844	28.600000381469727	29.25	1270700
Fri Oct 24 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	29.11000061035156	30.09000015258789	29.11000061035156	29.75	1540700
Mon Oct 27 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	29.850000381469727	30.290000915527344	29.3700008392334	30.100000381469727	766700
Tue Oct 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	30.299999237060547	31.290000915527344	29.940000534057617	30.649999618530277	536200
Wed Oct 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	30.649999618530277	31	29.940000534057617	30	596300
Thu Oct 30 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	30.149999618530277	30.690000534057617	29.75	30.25	415600
Fri Oct 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	30.25	31.979999542236328	30.25	31.5	29854300


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