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)	NIACL	138.85	138.75	139.15	136.55	137.05	249463	343.75	3677	129463	51.900001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	137.05	137	137.45	135.3	135.85	207801	282.68	5558	91164	43.869998931884766
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	135.85	137.35	137.55	135	135.8	189380	257.47	3030	96610	51.0099983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	135.8	136.5	139.8	135.65	138.65	239782	330.3	4241	70646	29.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	138.15	137.45	139.65	135.9	136.9	250879	345.79	4507	106184	42.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	138.65	139.5	139.5	137.45	138.15	170026	235.37	2749	82439	48.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	140.65	140.65	140.95	138.2	138.85	219661	305.8	3845	117867	53.65999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	135.45	136.7	136.9	134.55	134.95	107723	145.87	2001	42716	39.65
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	134.95	135	148.4	133.8	145.25	1262996	1820.97	15523	310212	24.56
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NIACL	145.25	144	148	140.55	145.55	518604	750.07	8487	194236	37.45


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