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.813969124052516	14.558707034088828	13.586915062753915	14.10459804534912	7717000
Thu Jun 20 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.758514168580346	14.803924288492732	13.9502013884591	14.02285861968994	1874600
Fri Jun 21 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.513292722426218	14.513292722426218	14.04102080537026	14.349814414978027	635300
Mon Jun 24 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.34073510505652	14.34073510505652	13.795804987616515	14.0955171585083	758300
Tue Jun 25 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.07735227487257	14.231749111049671	13.94112017995985	14.22266674041748	564400
Wed Jun 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.113678036843629	14.12276040563896	13.904788751405183	14.050103187561035	901000
Thu Jun 27 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.42343517905411	14.2953227647628	13.31444933910833	13.959282875061035	3258000
Fri Jun 28 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.88662607027249	14.240830710462994	13.850297455853656	13.968365669250488	1793700
Mon Jul 01 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	14.059187193540138	14.077351934365144	13.477929345420142	13.505175590515137	4343500
Tue Jul 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	13.332614002670503	13.795803603258332	13.32353163285796	13.614160537719728	8682500


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