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)	BHARTIARTL	721.65	721.1	723.25	716.5	720.2	3284198	23648.97	93139	1704869	51.90999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	720.2	718	720.1	699.5	706.5	6833983	48357.4	115571	3830394	56.04999923706055
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	706.5	711.2	714.7	701	708.9	7167684	50648.6	111904	3368670	47
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	708.9	707.1	726.1	702.15	719.35	10185173	72911.76	144952	4524854	44.43000030517578
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	724.05	721.7	725.4	710.9	715.15	5646980	40451.11	118668	3428094	60.709999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	719.35	722.95	726.95	708.6	724.05	6074014	43664.41	176435	2930229	48.2400016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	725.05	726	729	718.5	721.65	3651578	26415.91	105929	2106096	57.68000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	455.8	456.05	460.5	449.75	453.3	5059995	22998.87	67334	1123980	22.21
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	453.3	454.1	459.4	453.5	455.2	4842142	22057.87	78890	1761330	36.38
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BHARTIARTL	455.2	455.7	459.2	451.5	455.1	5059594	23010.88	97228	1968386	38.9


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