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	BORNOIL [S]	7036	s	0.015	0.015	-	-	581,640	689,449	0.015	0.020	626,834	0.020	0.015	20200318
1	2	DNEX [S]	4456	s	0.075	0.090	-0.015	-16.67	437,258	83,256	0.070	0.075	82,664	0.090	0.070	20200318
2	3	ACO [S]	0218	0.200	-	-0.080	-28.57	412,191	2,294	0.200	0.205	7,362	0.245	0.190	0218	20200318
3	4	SAPNRG [S]	5218	s	0.085	0.090	-0.005	-5.56	345,333	601,462	0.080	0.085	332,583	0.090	0.080	20200318
4	5	JAKS [S]	4723	s	0.755	0.755	-	-	338,280	4,157	0.745	0.755	1,248	0.790	0.735	20200318
5	6	VELESTO [S]	5243	s	0.120	0.120	-	-	288,275	70,163	0.115	0.120	81,952	0.130	0.115	20200318
6	7	HIBISCS [S]	5199	s	0.290	0.290	-	-	261,364	32,558	0.285	0.290	11,794	0.305	0.285	20200318
7	8	MYEG [S]	0138	s	0.900	0.915	-0.015	-1.64	255,528	4,871	0.900	0.905	1,071	0.940	0.890	20200318
8	9	VC [S]	0060	0.020	0.020	-	-	245,688	1,500,119	0.020	0.025	43,740	0.025	0.020	0060	20200318
9	10	AIRASIA [S]	5099	s	0.615	0.625	-0.010	-1.60	183,869	2,638	0.610	0.615	1,072	0.650	0.605	20200318


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