S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Tue Apr 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	17.899999618530273	17.920000076293945	15.149999618530272	15.350000381469728	3531700
Wed Apr 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.350000381469728	16.09000015258789	15.210000038146973	15.619999885559082	266500
Thu Apr 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.949999809265137	16.549999237060547	15.710000038146973	16.25	262100
Mon Apr 21 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16.59000015258789	16.59000015258789	16.010000228881836	16.100000381469727	78000
Tue Apr 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16.200000762939453	16.68899917602539	15.760000228881836	15.979999542236328	96100
Wed Apr 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.81999969482422	16.18000030517578	15.800000190734863	16.06999969482422	56500
Thu Apr 24 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	16.280000686645508	16.299999237060547	15.75	15.75	42800
Fri Apr 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.75	15.75	15.25	15.300000190734863	71600
Mon Apr 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.43000030517578	15.65999984741211	14.510000228881836	14.970000267028809	197500
Tue Apr 29 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15.010000228881836	15.449999809265137	15.010000228881836	15.279999732971191	68500


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