Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Apr 25 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	4.11	4.34	4	4.2	4.2	499200
Thu Apr 26 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	4.12	4.2	4.12	4.2	4.2	43100
Fri Apr 27 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	4.2	4.28	4.17	4.28	4.28	31000
Mon Apr 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	4.39	6.57	4.26	4.84	4.84	132100
Tue May 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	5.5	5.5	4.91	5.2	5.2	63000
Wed May 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	5.25	5.25	5	5.24	5.24	22000
Thu May 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	5.37	8.16	5.24	6	6	123700
Fri May 04 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	6.01	7.45	6.01	7.44	7.44	354800
Mon May 07 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	8.22	9.75	7.81	9.39	9.39	448200
Tue May 08 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	9.2	9.25	8.02	8.43	8.43	188600


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