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)	DALBHARAT	1941.7	1950	1960	1920.15	1940.2	161686	3138.34	12267	76968	47.59999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1940.2	1940.2	1986.45	1922.6	1978.6	259444	5086.29	14998	87309	33.650001525878906
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1978.6	1993.05	2015	1935	1939.95	152058	2994.33	11107	29101	19.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1939.95	1948.7	1985.8	1935.45	1969.3	195396	3829.75	8346	78594	40.220001220703125
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1948.15	1930.4	1950.5	1876	1898.95	153632	2923.3	9042	78987	51.40999984741211
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1969.3	1970.05	1976.05	1915	1948.15	84587	1644.28	5481	29660	35.060001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	1919.55	1914	1970.7	1906.4	1941.7	442397	8561.07	21374	150029	33.90999984741211
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	800.3	810	814	791.25	805	38108	306.42	1707	20202	53.01
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	805	804	832	800.1	820	173072	1418.94	5272	111891	64.65
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DALBHARAT	820	820	830	801	803.75	157209	1279.08	5143	128124	81.5


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