S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Oct 13 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	20.26764800868084	20.931737295679863	19.83642145530465	20.91448783874512	396800
Fri Oct 14 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.00935386600137	21.983924951469312	21.00935386600137	21.863182067871094	402600
Mon Oct 17 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.992550158493398	22.251285384711583	21.699316024780277	21.699316024780277	583400
Tue Oct 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.613078233628173	21.871815198611177	21.475085843636855	21.768320083618164	423500
Wed Oct 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.776937234281288	21.86318285925833	21.34571075439453	21.34571075439453	722200
Thu Oct 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.388832744383816	21.587198175330563	20.983480445489715	21.34571075439453	549700
Fri Oct 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.56132274996348	22.208162432462384	21.518200762462904	22.027048110961918	1764500
Mon Oct 24 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	21.992551570576115	22.29441045054452	21.992551570576115	22.225414276123047	371300
Tue Oct 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	22.32028237858802	22.492773632432765	21.561324480667857	22.20816421508789	546800
Wed Oct 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	22.50139961013597	22.50139961013597	21.44058278153205	21.578575134277344	657300


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