S&P500 Stock Prices

date Date	open Open	high High	low Low	close Close	volume Volume
Tue Jul 13 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.566961853592484	6.613868902910797	6.32773670727888	6.332427501678467	14964100
Wed Jul 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.332424108206276	6.355877620296969	6.055673649680873	6.304279804229736	2801000
Thu Jul 15 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.308973978859976	6.496601728849196	6.262067376866753	6.491910934448242	1276200
Fri Jul 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.505982061581412	6.520053995696279	6.337117510186845	6.487219333648682	1488200
Mon Jul 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.47314644150841	6.47314644150841	6.262065671670467	6.3418073654174805	966200
Tue Jul 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.341807748598884	6.534125804901122	6.290209915798697	6.534125804901123	719300
Wed Jul 21 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.538816942016256	6.538816942016256	6.332426927863095	6.379333972930908	472300
Thu Jul 22 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.379333972930908	6.40278704812608	6.252685219651053	6.379333972930908	218500
Fri Jul 23 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.285519078779602	6.3887142963252765	6.285519078779602	6.360570430755615	268500
Mon Jul 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	6.332426379412253	6.332426379412253	6.12134558956625	6.191705703735352	236200


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