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)	BPCL	377.05	377.15	380	374.05	375.65	4478855	16851.25	74136	1988424	44.400001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	375.65	378	378.4	370.1	372.45	4094513	15269.84	73872	1913507	46.72999954223633
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	372.45	374.4	378.5	370.65	377.4	3454806	12936.5	62251	1463179	42.34999847412109
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	377.4	380	382	374.7	375.6	4646178	17512.13	64621	2488809	53.56999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	369.65	369.65	374.5	365	369.55	5631276	20878.44	68773	2327055	41.31999969482422
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	375.6	372.7	373.5	368.5	369.65	6141529	22736.24	104978	3192486	51.97999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	382.1	384	384.9	376.5	377.05	5329147	20201.27	86916	2897384	54.369998931884766
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	491.55	492	493.9	488.5	491.65	2383296	11714.58	27812	305674	12.83
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	491.65	491.2	491.7	486.45	487.55	3212483	15687.41	37044	932646	29.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BPCL	487.55	483.9	486.75	472.85	483.5	11327770	54532.23	115581	3142382	27.74


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