S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Thu Jan 26 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	45	48.27999877929688	39.5099983215332	44	13218600
Fri Jan 27 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	44.880001068115234	44.900001525878906	41.75	42.20000076293945	1150800
Mon Jan 30 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	42.20000076293945	45.5099983215332	41.25	44.79999923706055	735800
Tue Jan 31 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	45.5	49.29999923706055	45.380001068115234	47.52000045776367	1111200
Wed Feb 01 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	48.900001525878906	49.2400016784668	45.25	46.560001373291016	606700
Thu Feb 02 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	47.900001525878906	47.90999984741211	44.2599983215332	44.75	401500
Fri Feb 03 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	44.84999847412109	46.560001373291016	44.25	46.54999923706055	245300
Mon Feb 06 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	47.47999954223633	48	46	47.709999084472656	349800
Tue Feb 07 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	47.709999084472656	47.75	45.25	46.27999877929688	267200
Wed Feb 08 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	45.84999847412109	46.59999847412109	45.040000915527344	45.7400016784668	174400


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