S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Wed Jun 19 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.84942477385048	14.728609719112134	13.776914764384312	14.320740699768066	31981500
Thu Jun 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.837376670337	14.837376670337	13.822234735648028	13.8675537109375	9274200
Fri Jun 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.230101824484096	14.320739762578953	13.95818887458696	14.157591819763184	8323500
Mon Jun 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.175721202082052	14.35699623241302	13.776915270966397	14.076019287109377	4279700
Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.094147888654666	14.266358959513695	13.912872849753697	14.248231887817385	3577300
Wed Jun 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.221037996391942	14.221037996391942	13.758786927888004	13.958189010620115	14755100
Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.903809045841625	14.384188120696804	13.459684979194618	14.048829078674316	12121700
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.04882815626801	14.293550093896108	13.82223415374756	13.82223415374756	16988100
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.40530014038086	14.13040106646762	13.369045137295894	13.40530014038086	25839400
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.31466230442802	13.70440423892487	13.31466230442802	13.5956392288208	30520100


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