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)	TATACONSUM	738.1	741	746.55	722.2	733.8	1931658	14152.39	62799	619579	32.06999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	733.8	729	736.75	702.05	704.8	1908753	13642.03	64955	703359	36.84999847412109
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	704.8	705.1	710	691.35	697.1	2410446	16834.5	66944	1156275	47.970001220703125
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	697.1	706	709	696.55	700.2	2206837	15501.09	41971	845612	38.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	706.7	695	703.1	690	701	2013324	14025.55	73823	1049818	52.13999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	700.2	706.25	711	699	706.7	1770292	12512.48	71319	946885	53.4900016784668
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	742.45	750	769	733.35	738.1	8154082	61278.38	189655	1405225	17.229999542236328
Thu Feb 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	365.65	364.1	365.65	360.25	363.3	1827751	6631.72	25087	956756	52.35
Fri Feb 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	363.3	357.95	357.95	341.55	346.15	4494646	15574.23	36885	3022910	67.26
Mon Mar 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	TATACONSUM	346.15	351.05	355.25	333.6	338.8	3837169	13353.81	48165	2115419	55.13


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