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	SAPNRG [S]	5218	s	0.090	0.095	-0.005	-5.26	1,816,455	247,517	0.090	0.095	440,573	0.095	0.080	20200317
1	2	HIBISCS [S]	5199	s	0.315	0.305	+0.010	+3.28	1,181,335	13,841	0.310	0.315	10,412	0.320	0.260	20200317
2	3	VELESTO [S]	5243	s	0.130	0.125	+0.005	+4.00	640,419	71,038	0.125	0.130	89,486	0.130	0.105	20200317
3	4	JAKS [S]	4723	s	0.775	0.700	+0.075	+10.71	606,190	432	0.775	0.780	4,992	0.780	0.620	20200317
4	5	AIRASIA [S]	5099	s	0.660	0.700	-0.040	-5.71	524,670	2,102	0.655	0.660	782	0.665	0.580	20200317
5	6	BORNOIL [S]	7036	s	0.015	0.010	+0.005	+50.00	516,921	1,304,078	0.010	0.015	380,001	0.020	0.010	20200317
6	7	EKOVEST [S]	8877	s	0.395	0.390	+0.005	+1.28	482,676	1,767	0.390	0.395	4,379	0.395	0.325	20200317
7	8	DNEX [S]	4456	s	0.095	0.110	-0.015	-13.64	465,115	45,197	0.095	0.100	39,114	0.100	0.085	20200317
8	9	MYEG [S]	0138	s	0.905	0.885	+0.020	+2.26	443,071	1,615	0.900	0.905	1,285	0.910	0.780	20200317
9	10	PWORTH [S]	7123	s	0.010	0.010	-	-	384,587	273,622	0.010	0.015	734,232	0.015	0.010	20200317


CREATE TABLE n_20200317_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
);