S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Jul 06 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	38	39.75	36	36.709999084472656	5866600
Tue Jul 07 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	37.720001220703125	37.810001373291016	36	36.619998931884766	7359000
Wed Jul 08 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	36.34000015258789	36.36000061035156	34.529998779296875	34.70000076293945	5387700
Thu Jul 09 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	35.099998474121094	35.52000045776367	33.9900016784668	34.5	3760100
Fri Jul 10 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	34.65999984741211	35.189998626708984	33.97999954223633	34.689998626708984	4472800
Mon Jul 13 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	35.59000015258789	37.5	35.5	36.77999877929688	7626000
Tue Jul 14 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	36.9900016784668	37.7400016784668	36.59999847412109	36.93000030517578	4653300
Wed Jul 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	37.97999954223633	38.20000076293945	37.02999877929688	37.5099983215332	13072800
Thu Jul 16 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	38.81999969482422	39.970001220703125	38.08000183105469	38.630001068115234	21348500
Fri Jul 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	39.41999816894531	40.20000076293945	38.18000030517578	38.38999938964844	45720200


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