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)	HINDZINC	323.3	325	330.9	321.85	329.65	826825	2712.18	15309	311368	37.65999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	329.65	330.45	335.9	329.7	334.05	1048595	3496.2	18539	504727	48.130001068115234
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	334.05	336.2	337.4	324.9	327.3	667055	2200.15	14787	243558	36.5099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	327.3	329.9	334.5	326.05	331.7	434764	1441.89	8659	179514	41.290000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	331.8	328	331.35	326	327.05	275139	903.77	6409	128604	46.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	331.7	334	338	331.05	331.8	691056	2312.78	11569	212476	30.75
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	320.45	321.85	326.5	321	323.3	619741	2011.15	12121	208591	33.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	209.65	210.8	211.5	209.6	210.1	88791	186.77	1917	36874	41.53
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	210.1	211.4	214.95	210.55	214.15	549833	1175.35	11848	247861	45.08
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	HINDZINC	214.15	214	216.9	213.1	215.25	816967	1760.96	15442	559230	68.45


CREATE TABLE hindzinc (
  "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
);