Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Wed Apr 09 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.4	28.4	28	28.040001	28.040001	56750
Thu Apr 10 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Fri Apr 11 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Mon Apr 14 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Tue Apr 15 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.08	28.08	28.040001	28.040001	28.040001	7500
Wed Apr 16 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.16	28.16	28.040001	28.040001	28.040001	6275
Thu Apr 17 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Fri Apr 18 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Mon Apr 21 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001
Tue Apr 22 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	28.040001	28.040001	28.040001	28.040001	28.040001


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