Pakistan Stock Exchange Complete

date Date	open Open	high High	low Low	close Close	volume Volume
Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.28	7.28	7.28	7.28	500
Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.17	7.44	7.01	7.11	17500
Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.04	7.24	7.02	7.08	38000
Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	6.71	7.19	6.7	7	17500
Mon Jan 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7	7.6	7	7.53	55500
Tue Jan 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.15	7.48	7.11	7.25	3500
Wed Jan 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.1	7.55	7.1	7.33	43500
Thu Jan 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.26	8	7.25	7.62	81500
Fri Jan 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.8	7.8	7.19	7.5	17500
Mon Jan 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	7.49	7.49	7.11	7.28	4500


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