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)	ADANITRANS	2006.2	2014	2050	1987.85	2033.1	328615	6670.4	4292
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	2033.1	2033.1	2069.5	2000	2028.5	43314	880.04	4509
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	2028.5	2044	2045	1935	1968.3	261310	5266.08	4727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	1968.3	1969.95	2018	1932.1	1955.2	257200	5096.93	4665
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	2036.4	2050	2050	1980	2016.05	247110	5012.71	8784
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	1955.2	1955.9	2052.95	1955.3	2036.4	301717	6028.94	9339
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	2016	2010	2040	1977	2006.2	325157	6597.75	3019
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	331.4	332.95	336	330	333.9	147701	492.47	3178	49581	33.57
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	333.9	335	366.4	332.6	356.65	1195881	4229.07	16312	323618	27.06
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ADANITRANS	356.65	354.65	356.1	343	346.55	355922	1249.23	8697	137971	38.76


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