Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Oct 12 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.446667	8.49	8.443333	8.49	8.313635	24000
Fri Oct 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.533333	8.59	8.53	8.583333	8.405028	30600
Mon Oct 16 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.61	8.66	8.6	8.643333	8.463781	103500
Tue Oct 17 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.633333	8.633333	8.496667	8.586667	8.408293	15600
Wed Oct 18 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.663333	8.663333	8.52	8.523333	8.346275	21300
Thu Oct 19 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.58	8.58	8.563333	8.57	8.391972	2400
Fri Oct 20 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.473333	8.496667	8.473333	8.476667	8.300578	14400
Mon Oct 23 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.483333	8.573333	8.483333	8.54	8.362596	20700
Tue Oct 24 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.493333	8.5	8.463333	8.463333	8.287522	25800
Wed Oct 25 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.51	8.526667	8.51	8.526667	8.349538	4800


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