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)	INDIGOPNTS	1985.15	1980	1985	1970	1977.55	6645	131.46	1061	4149	62.43999862670898
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1977.55	1972.4	1996.75	1935	1973.9	17591	344.34	5373	6762	38.43999862670898
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1973.9	1973.9	1984.3	1929	1941.4	12353	240.35	2989	6465	52.34000015258789
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1941.4	1944.4	1956.1	1925	1933.65	11081	214.55	1865	7127	64.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1934.8	1934	1999	1905.5	1933.65	12300	236.53	2283	6820	55.45000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1933.65	1935	1945	1924.05	1934.8	10996	212.68	2530	5239	47.63999938964844
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1994	1994	2009.9	1981.5	1985.15	6505	129.27	1256	3908	60.08000183105469
Tue Feb 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	1490	2607.5	3129	2436.05	3117.15	12652036	339624.47	812580	5456304	43.13
Wed Feb 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	3117.15	3239	3329.95	2831.25	2924.25	2955005	91173.29	375333	521407	17.64
Thu Feb 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	INDIGOPNTS	2924.25	2948.85	2967.95	2853	2873.75	476054	13818.29	73464	105294	22.12


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