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)	ABFRL	304.15	305.4	306.7	293.5	295.5	6354420	19125.83	71994	1169175	18.399999618530277
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	295.5	295	305.35	287.55	290.75	6659707	19721.95	46011	2952888	44.34000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	290.75	291.55	293.7	284	289.1	2167674	6250.15	23158	568518	26.229999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	289.1	292.1	299.5	289.4	298.55	2517367	7403.32	25730	616798	24.5
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	295.6	292	293.5	285	287.1	1797849	5211.3	23308	714422	39.7400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	298.55	299.9	301.4	293.6	295.6	2514519	7480.24	24868	465815	18.530000686645508
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	307.25	305.8	310.35	302.75	304.15	2651856	8113.7	23591	1265114	47.709999084472656
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	231.7	232.9	236.85	230.15	234.1	241005	565.33	4836	79395	32.94
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	234.1	232.65	249.7	232.6	240.9	1143769	2758.34	13585	685865	59.97
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ABFRL	240.9	239	243.95	237.65	239.9	336401	808.38	10554	149339	44.39


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