S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Jun 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	23.75	24.75	22.82999992370605	24.600000381469727	10922400
Mon Jul 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24.75	25.200000762939453	24.100000381469727	24.770000457763672	656700
Tue Jul 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24.850000381469727	25.31999969482422	24.600000381469727	25.309999465942383	401100
Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.5	26.26000022888184	25.13999938964844	25.959999084472656	541000
Fri Jul 06 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.75	26.1200008392334	25.100000381469727	25.84000015258789	355100
Mon Jul 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.959999084472656	26.299999237060547	25.18000030517578	25.270000457763672	152400
Tue Jul 10 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.21999931335449	25.690000534057617	25.049999237060547	25.049999237060547	304000
Wed Jul 11 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.020000457763672	25.350000381469727	23.489999771118164	23.739999771118164	296500
Thu Jul 12 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	23.299999237060547	24.46999931335449	22.6200008392334	24.07999992370605	325500
Fri Jul 13 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24.690000534057617	24.920000076293945	23.979999542236328	24.18000030517578	89100


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