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.303333	8.306667	8.29	8.296667	8.143849	25500
Fri Oct 13 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.343333	8.343333	8.306667	8.326667	8.173297	10800
Mon Oct 16 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.366667	8.366667	8.356667	8.356667	8.202744	5700
Tue Oct 17 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.306667	8.316667	8.29	8.316667	8.163481	9900
Wed Oct 18 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4	8.4	8.333333	8.356667	8.202744	129900
Thu Oct 19 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.393333	8.393333	8.366667	8.366667	8.21256	6000
Fri Oct 20 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.396667	8.413333	8.383333	8.406667	8.251822	7200
Mon Oct 23 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.386667	8.44	8.386667	8.413333	8.258367	37800
Tue Oct 24 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4	8.42	8.363333	8.37	8.215832	15900
Wed Oct 25 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	8.34	8.34	8.313333	8.313333	8.160208	35100


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