S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Apr 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	28.899999618530277	31.75	28.649999618530277	31.209999084472656	13590200
Fri Apr 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	30.950000762939453	31.5	29.68000030517578	30.520000457763672	1744900
Mon Apr 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	30.76000022888184	32	30.209999084472656	31.57999992370605	638900
Tue May 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	31.420000076293945	32.400001525878906	31.26000022888184	31.479999542236328	858600
Wed May 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	31.479999542236328	33.650001525878906	31.479999542236328	32.75	845500
Thu May 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	32.630001068115234	34.43000030517578	32.529998779296875	33.790000915527344	1807900
Fri May 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	33.880001068115234	34.88999938964844	33.79999923706055	34.09000015258789	679600
Mon May 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	34.09000015258789	34.70000076293945	33.900001525878906	33.9900016784668	325600
Tue May 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	34.47999954223633	34.77000045776367	32.459999084472656	32.95000076293945	413900
Wed May 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	33.130001068115234	34.25	33.04499816894531	33.470001220703125	466700


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