S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Jul 31 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20.32999992370605	19.299999237060547	19.989999771118164	14208300
Fri Aug 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20	20.100000381469727	19.34000015258789	19.850000381469727	2125600
Mon Aug 04 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.850000381469727	20.100000381469727	19.600000381469727	20.01000022888184	592800
Tue Aug 05 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	19.940000534057617	20.479999542236328	19.770000457763672	20.209999084472656	1077600
Wed Aug 06 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.200000762939453	20.32999992370605	20.049999237060547	20.32999992370605	900900
Thu Aug 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.32999992370605	20.489999771118164	20.299999237060547	20.420000076293945	546000
Fri Aug 08 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.489999771118164	20.68000030517578	20.399999618530277	20.530000686645508	402500
Mon Aug 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.51000022888184	20.600000381469727	20.440000534057617	20.5	442500
Tue Aug 12 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.450000762939453	20.549999237060547	20.450000762939453	20.5	240700
Wed Aug 13 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	20.5	20.600000381469727	20.46999931335449	20.530000686645508	438500


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