Malaysian Islamic Equity Trend Prediction

unnamed_0 Unnamed: 0	no NO	name NAME	code CODE	rem REM	last_done LAST DONE	lacp LACP	chg CHG	n__chg %CHG	vol_00 VOL(\u002700)	buy_vol_00 BUY VOL(\u002700)	buy BUY	sell SELL	sel_vol_00 SEL VOL(\u002700)	high HIGH	low LOW	date Date
	1	JAKS [S]	4723	s	0.920	1.050	-0.130	-12.38	699,165	3,007	0.915	0.920	3,681	0.990	0.890	20200312
1	2	HIBISCS [S]	5199	s	0.410	0.435	-0.025	-5.75	514,906	17,978	0.405	0.410	27,394	0.425	0.400	20200312
2	3	BORNOIL [S]	7036	s	0.025	0.030	-0.005	-16.67	400,100	404,214	0.020	0.025	104,782	0.030	0.025	20200312
3	4	VELESTO [S]	5243	s	0.170	0.185	-0.015	-8.11	376,336	24,954	0.170	0.175	67,186	0.180	0.165	20200312
4	5	SAPNRG [S]	5218	s	0.110	0.115	-0.005	-4.35	362,018	414,374	0.105	0.110	376,036	0.110	0.105	20200312
5	6	DAYANG [S]	5141	s	1.240	1.330	-0.090	-6.77	329,706	2,380	1.230	1.240	1,426	1.290	1.180	20200312
6	7	CAREPLS [S]	0163	0.310	0.295	+0.015	+5.08	316,093	3,825	0.310	0.315	17,318	0.320	0.305	0163	20200312
7	8	VC [S]	0060	0.050	0.055	-0.005	-9.09	277,560	599,725	0.050	0.055	13,325	0.060	0.050	0060	20200312
8	9	SUPERMX [S]	7106	s	1.820	1.730	+0.090	+5.20	248,900	1,128	1.810	1.820	1,092	1.860	1.760	20200312
9	10	TIGER [S]	7079	s	0.040	0.040	-	-	240,542	223,475	0.040	0.045	92,168	0.045	0.040	20200312


CREATE TABLE n_20200312_fulldump (
  "unnamed_0" BIGINT,
  "no" BIGINT,
  "name" VARCHAR,
  "code" VARCHAR,
  "rem" VARCHAR,
  "last_done" VARCHAR,
  "lacp" VARCHAR,
  "chg" VARCHAR,
  "n__chg" VARCHAR,
  "vol_00" VARCHAR,
  "buy_vol_00" VARCHAR,
  "buy" VARCHAR,
  "sell" VARCHAR,
  "sel_vol_00" VARCHAR,
  "high" VARCHAR,
  "low" VARCHAR,
  "date" BIGINT
);