S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Feb 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	29.527056671995886	29.75202450828389	28.561568143526788	29.067747116088867	66789100
Mon Feb 04 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	29.14272757344608	29.98635715113361	28.83339666869782	29.077112197875977	7695400
Tue Feb 05 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	29.292711412138456	29.97698872163356	28.91776506364013	29.09586524963379	5013200
Wed Feb 06 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	29.03961550847397	29.46143117430269	28.824021629443664	29.086484909057617	2126100
Thu Feb 07 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	29.05836474895477	30.680008546175028	29.05836474895477	29.99573135375977	3800800
Fri Feb 08 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	30.28632339154991	31.38304086001437	30.27694772087189	30.97997283935547	2599300
Mon Feb 11 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	30.98934834434615	31.401788457707266	30.82062203075055	31.17681884765625	1487200
Tue Feb 12 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.308040491720345	31.87045892479134	31.073698881979237	31.626745223999023	1637300
Wed Feb 13 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.68299010080583	31.68299010080583	30.93309754220926	31.44864845275879	1269700
Thu Feb 14 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	31.29867839376008	31.35492169175792	30.717511950865447	31.18619537353516	2954500


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