S&P 500 Stock Prices

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Tue Nov 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4375	8.4375	8.4375	8.4375	8.4375	60000
Wed Nov 24 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4375	10.6875	8.4375	10.5	10.5	917700
Fri Nov 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	10.5	10.5	10.5	10.5	10.5	32700
Mon Nov 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	10.625	10.625	9.25	9.25	9.25	511000
Tue Nov 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.375	9.375	8.5	8.8125	8.8125	2424000
Wed Dec 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9	10.5	9	9.625	9.625	462000
Thu Dec 02 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	10	10	9.25	9.375	9.375	799500
Fri Dec 03 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.5	9.625	9.3125	9.4375	9.4375	292300
Mon Dec 06 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.375	9.6875	9.1875	9.25	9.25	239100
Tue Dec 07 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.1875	9.25	8.875	8.9375	8.9375	753300


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