S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Aug 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	12.347397531781878	13.373181254265935	12.337899316288585	13.297197341918944	10678500
Mon Aug 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	13.297197341918944	13.297197341918944	13.012257217717888	13.297197341918944	1819500
Tue Aug 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	13.078744336352338	13.14523003582902	12.898281858058889	12.917278289794922	1579300
Wed Aug 11 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	12.584847094965916	12.708321175159654	11.825007089204268	12.109947204589844	2588200
Thu Aug 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.644546538983992	11.881996504758709	11.492578705816133	11.768020629882812	1780300
Fri Aug 13 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.635047256946564	11.9009909406243	11.255127708835518	11.397597312927246	957600
Mon Aug 16 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.198141672650417	11.616053263234043	11.103161312799667	11.188643455505373	551600
Tue Aug 17 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.264627368285824	11.682539864195157	11.160149697208412	11.606555938720703	1086700
Wed Aug 18 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.473581222549456	11.967477540893473	11.397597312927248	11.397597312927246	1010600
Thu Aug 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	11.350108694591809	11.49257922395977	10.74223733451445	10.970189094543455	746000


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