NIFTY ALL STOCK Dataset

date Date	symbol Symbol	pre_close Pre Close	open Open	high High	low Low	close Close	volume Volume	turnover_lacs Turnover Lacs	no_of_trades No Of Trades	deliv_volume Deliv Volume	deliv Deliv %
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	174.65	175	183.45	174.15	178.95	1386791	2493.98	19104	307799	22.200000762939453
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	178.95	179.6	180.8	175.6	176.5	234722	418.83	5632	87398	37.22999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	176.5	176.5	178.35	173.4	176.55	180843	317.73	4215	71754	39.68000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	176.55	177	177.95	174.75	177.65	175053	309.27	4090	82325	47.02999877929688
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	178.05	177	189	174.1	186.15	1337733	2479.27	20227	348467	26.049999237060547
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	177.65	178	179.95	176.2	178.05	255420	455.79	5512	105665	41.369998931884766
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	172.55	172.4	177.3	171.55	174.65	519478	911.99	8656	169602	32.650001525878906
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	146.5	146.65	147.8	145.8	146.3	101971	149.73	1896	50396	49.42
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	146.3	147.5	158.8	147.5	154.6	3707232	5723.46	30845	1110922	29.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	MOIL	154.6	153.8	156.6	152	154.35	564491	873.33	15680	334877	59.32


CREATE TABLE moil (
  "date" TIMESTAMP,
  "symbol" VARCHAR,
  "pre_close" DOUBLE,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "volume" BIGINT,
  "turnover_lacs" DOUBLE,
  "no_of_trades" BIGINT,
  "deliv_volume" DOUBLE,
  "deliv" DOUBLE
);