Nasdaq Stock Market Data

date Date	open Open	high High	low Low	close Close	adj_close Adj Close	volume Volume
Thu Jul 19 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	27.200001	33.240002	26	31.25	31.25	4438200
Fri Jul 20 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	30.290001	37	30.25	35.049999	35.049999	697700
Mon Jul 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	35.049999	38.529999	34	36.290001	36.290001	1008700
Tue Jul 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	36.240002	38.830002	35.09	38.119999	38.119999	293800
Wed Jul 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	38.299999	40.139999	37.82	39.299999	39.299999	543600
Thu Jul 26 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	39.5	40.450001	39.169998	39.970001	39.970001	369600
Fri Jul 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	40	40.830002	39.040001	39.790001	39.790001	135100
Mon Jul 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	39.84	40.400002	39	40	40	63700
Tue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	39.779999	43.959999	39.5	40.77	40.77	175100
Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	41.509998	45.950001	40.689999	40.950001	40.950001	434800


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