Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Jul 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	17.776737	18.709074	10.134082	11.153726	11.153726	18751970
Thu Jul 21 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	11.961335	12.160898	10.289991	10.352354	10.352354	3136125
Fri Jul 22 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	10.364827	10.991581	10.289991	10.685999	10.685999	1208398
Mon Jul 25 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	10.601809	11.163081	10.601809	11.100717	11.100717	854024
Tue Jul 26 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	11.362644	11.412535	10.835672	11.359526	11.359526	952479
Wed Jul 27 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	11.356408	11.356408	10.371063	10.464609	10.464609	810088
Thu Jul 28 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	10.545681	10.894917	10.523854	10.570627	10.570627	513441
Fri Jul 29 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	10.134082	10.289991	9.946991	10.046773	10.046773	533324
Mon Aug 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	10.277518	10.277518	9.407546	9.423137	9.423137	413382
Tue Aug 02 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	9.448082	9.448082	8.453383	8.52822	8.52822	1058631


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