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)	TV18BRDCST	65.05	65.65	67.85	63.55	65	23477902	15488.08	57721	5716871	24.350000381469727
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	65	65	65.7	62.1	63.55	8741118	5589.29	22341	3999184	45.75
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	63.55	63.95	64.2	59.2	62.25	9686312	5956.13	31469	4040536	41.709999084472656
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	62.25	63.05	70	63.05	69.45	42392239	28965.97	93512	17244952	40.68000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	74.4	73.65	76.25	70.6	71.75	25140455	18499.76	71738	8483418	33.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	69.45	70	76.9	70	74.4	50262757	36971.6	126230	15590281	31.020000457763672
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	60.95	61.1	67.45	60.3	65.05	48124717	31437.91	105775	12767190	26.530000686645508
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	21.15	21.25	21.4	21.2	21.25	577021	122.8	1091	369495	64.03
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	21.25	21.3	23	21.2	22.3	3218907	710.83	4804	1730540	53.76
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TV18BRDCST	22.3	22.45	22.45	21.85	21.95	1905671	421.19	3599	929910	48.8


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