S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Fri Aug 08 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.987020289575728	31.987020289575728	30.9260909267374	31.40350914001465	245500
Mon Aug 11 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.403526163667895	31.615712151260247	30.66087520709467	31.244386672973636	243600
Tue Aug 12 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.1913320473608	31.40351797965577	31.138285564287056	31.35047149658203	405500
Wed Aug 13 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.40352793375651	31.827899932861328	30.342597935994466	31.827899932861328	405700
Thu Aug 14 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.61572440195892	31.721817436864814	30.8730731576176	31.29744529724121	195600
Fri Aug 15 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	31.085248540551035	31.19134153898295	30.342597551527632	30.607830047607425	260500
Mon Aug 18 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	30.713923046039334	30.766969545255293	30.23650455309572	30.607830047607425	180600
Tue Aug 19 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	30.55478232624621	30.66087532043457	29.49385238436267	30.66087532043457	703300
Wed Aug 20 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	30.554774172067223	30.766960103817688	29.91821637681582	30.183448791503903	1029500
Thu Aug 21 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	30.13040333975733	30.3425892787697	29.812124431238765	29.971263885498047	1406500


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