Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Fri Jul 17 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.5	16.139999	15.31	15.92	11.554183	4330300
Mon Jul 20 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.92	16.1	15.01	15.11	10.966313	314100
Tue Jul 21 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.13	15.79	15	15.65	11.358227	204000
Wed Jul 22 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.59	15.91	15.3	15.65	11.358227	67100
Thu Jul 23 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.55	15.95	15.55	15.67	11.372742	41900
Fri Jul 24 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.57	15.82	15.31	15.66	11.365484	56500
Mon Jul 27 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.95	15.95	15.25	15.42	11.1913	168900
Tue Jul 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.27	15.69	15	15.47	11.22759	148500
Wed Jul 29 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.26	15.75	15.24	15.48	11.234846	212800
Thu Jul 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	15.23	15.76	15.23	15.6	11.321939	143600


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