Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Nov 09 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	30	38.360001	29.23	35.919998	35.919998	2997200
Mon Nov 12 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34.279999	34.5	32.610001	33.200001	33.200001	509600
Tue Nov 13 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	33.75	35.689999	33	35.110001	35.110001	177100
Wed Nov 14 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	35.5	36.700001	34	35.049999	35.049999	99500
Thu Nov 15 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34	34.91	33.599998	34	34	103000
Fri Nov 16 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34.57	34.919998	33.5	33.740002	33.740002	165900
Mon Nov 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	33.5	34.419998	33.5	34.049999	34.049999	133400
Tue Nov 20 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34	35.689999	33.5	35.450001	35.450001	164200
Wed Nov 21 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	34.560001	35.98	33.560001	35.73	35.73	33900
Fri Nov 23 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	35.970001	36.830002	35.240002	36.490002	36.490002	31800


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