Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Jul 09 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.125	9.75	8.5	9.34375	9.34375	1006200
Mon Jul 12 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.4375	9.4375	8.5	8.875	8.875	143100
Tue Jul 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.96875	8.96875	8.6875	8.78125	8.78125	87600
Wed Jul 14 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.78125	9.1875	8.53125	9	9	113400
Thu Jul 15 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9.0625	9.0625	8.625	8.75	8.75	70800
Fri Jul 16 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.75	8.875	8.4375	8.625	8.625	137300
Mon Jul 19 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.53125	8.53125	7.75	8.125	8.125	63700
Tue Jul 20 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	7.9375	8.125	7.5	8.125	8.125	55100
Wed Jul 21 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.1875	8.3125	7.875	7.875	7.875	29200
Thu Jul 22 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8.125	8.125	7.75	7.75	7.75	16300


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