Pakistan Stock Exchange Complete

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.24	8.24	7.24	8.08	1790500
Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	8	8.66	7.9	8.37	2984000
Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	8.4	8.75	7.37	7.37	1472500
Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	6.37	6.59	6.37	6.37	1586000
Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.37	6.23	5.37	5.37	4405000
Mon Jan 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.16	5.17	4.7	5.01	1682500
Tue Jan 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.01	5.74	4.95	5.27	1197000
Wed Jan 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.4	5.55	5.09	5.16	557500
Thu Jan 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.29	5.3	4.92	4.97	454000
Fri Jan 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	5.1	5.1	4.8	4.96	1010000


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