Pakistan Stock Exchange Complete

date Date	open Open	high High	low Low	close Close	volume Volume
Mon Jul 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	22.05	22.05	22.05	22.05	202000
Tue Jul 31 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	23.15	23.15	23.15	23.15	3500
Wed Aug 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	24.3	24.3	24.3	24.3	699000
Thu Aug 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	25.51	25.51	24.7	25.51	3159500
Fri Aug 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	25.79	26.68	24.85	25.24	2945000
Mon Aug 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	25.5	25.5	24.55	24.83	475500
Tue Aug 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	24.72	26	24.57	25.8	1575500
Wed Aug 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	26.23	27.09	25.8	27.09	2061500
Thu Aug 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	27.95	28.44	27.5	27.92	5296000
Fri Aug 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	28.4	28.58	26.6	27.65	4611000


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