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)	BATAINDIA	1995.65	1995	1995.65	1935	1942.25	475094	9303.46	22272	194094	40.84999847412109
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1942.25	1931	1957.25	1893	1921.9	303211	5813.7	17904	69177	22.809999465942383
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1921.9	1929.85	1941.65	1860.1	1885.45	334836	6362.09	22663	59347	17.719999313354492
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1885.45	1894	1924.95	1853	1895.4	1153593	21737.95	55781	241797	20.959999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1900.8	1895	1895	1850	1859.45	297755	5559.4	20777	69929	23.489999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1895.4	1910.55	1918	1892.05	1900.8	500272	9538.35	33449	124019	24.790000915527344
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	2026.2	2029.9	2045.9	1980.05	1995.65	356130	7171.74	15597	119919	33.66999816894531
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1751.55	1751.55	1764.7	1743.5	1745.3	214199	3753.3	9131	30198	14.1
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1745.3	1748	1759.05	1732.2	1751	269100	4702.38	10240	38453	14.29
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BATAINDIA	1751	1751.1	1757.25	1730.15	1740.1	233227	4062.96	8789	37784	16.2


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