S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Wed Apr 23 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	14.478761672973633	15.076186562164766	14.211676974001248	14.478761672973633	23402800
Thu Apr 24 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	14.563100259587449	14.759899400876206	14.274930902340907	14.626357078552246	4960900
Fri Apr 25 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	14.759900981847572	14.93561408877433	14.54904578976931	14.879385948181152	1956800
Mon Apr 28 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	15.104304432533915	15.104304432533915	14.626364379812523	14.759906768798828	709400
Tue Apr 29 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	15.034018518036811	15.034018518036811	14.633392701684066	14.80910587310791	859700
Wed Apr 30 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	14.81613123364938	14.900474126849804	14.703674936438686	14.865330696105955	893300
Thu May 01 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	14.914531238486486	15.462756732522864	14.759904153771824	15.399499893188477	2999000
Fri May 02 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	15.5752113905037	15.5752113905037	15.104300158924858	15.469783782958984	1639400
Mon May 05 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	15.779040929194792	15.779040929194792	15.15350122250863	15.399499893188477	579000
Tue May 06 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	15.322183185965525	15.364355299045762	15.019957752398598	15.146470069885254	1040200


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