S&P 500 Stock Prices

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Aug 08 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	37.6875	37.6875	36.4375	37	29.61148452758789	245500
Mon Aug 11 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	37	37.25	36.125	36.8125	29.461408615112305	243600
Tue Aug 12 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	36.75	37	36.6875	36.9375	29.56145477294922	405500
Wed Aug 13 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	37	37.5	35.75	37.5	30.011632919311523	405700
Thu Aug 14 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	37.25	37.375	36.375	36.875	29.51143455505371	195600
Fri Aug 15 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	36.625	36.75	35.75	36.0625	28.86118698120117	260500
Mon Aug 18 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	36.1875	36.25	35.625	36.0625	28.86118698120117	180600
Tue Aug 19 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	36	36.125	34.75	36.125	28.91120719909668	703300
Wed Aug 20 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	36	36.25	35.25	35.5625	28.46103286743164	1029500
Thu Aug 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	35.5	35.75	35.125	35.3125	28.26094627380371	1406500


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