S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Nov 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.09999847412109	50.09000015258789	44	44.900001525878906	117701600
Fri Nov 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.93000030517578	46.93999862670898	40.68999862670898	41.650001525878906	27925300
Mon Nov 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	40.5	43	39.400001525878906	42.900001525878906	16113900
Tue Nov 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.65999984741211	43.77999877929688	41.83000183105469	41.900001525878906	6316700
Wed Nov 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41.02999877929688	42.869998931884766	40.7599983215332	42.59999847412109	8688300
Thu Nov 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	42.34000015258789	45.66999816894531	42.2400016784668	44.68999862670898	11099400
Fri Nov 15 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	45.25	45.27000045776367	43.43000030517578	43.97999954223633	8010600
Mon Nov 18 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	43.5	43.95000076293945	40.84999847412109	41.13999938964844	12810600
Tue Nov 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41.38999938964844	41.900001525878906	40	41.75	7436600
Wed Nov 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	41.400001525878906	41.75	40.5099983215332	41.04999923706055	5767300


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