S&P 500 Stock Prices

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Jul 28 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	14.9375	21.125	14.75	19.5859375	19.5859375	18615200
Mon Jul 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	19.125	19.34375	15.75	17.5	17.5	2481800
Tue Aug 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	17.40625	20.0625	16.5	17.75	17.75	1216200
Wed Aug 02 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	16.8125	19.5	16.78125	19.0625	19.0625	856400
Thu Aug 03 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	19.0625	23.875	18.5	22.125	22.125	1368000
Fri Aug 04 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	22.7421875	22.75	19.875	20.46875	20.46875	1284200
Mon Aug 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	21.46875	24.125	19.5	21.125	21.125	565600
Tue Aug 08 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	21.09375	22.25	20.28125	20.4921875	20.4921875	329600
Wed Aug 09 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	20.84375	21.40625	20	21.40625	21.40625	326800
Thu Aug 10 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	21.3125	23.625	20.75	22.5	22.5	657800


CREATE TABLE ilmn (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" DOUBLE
);