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)	ROUTE	1804.9	1802	1839.55	1790	1796.35	203021	3665.27	13520	67342	33.16999816894531
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1796.35	1795	1795	1745	1755.15	105474	1864.45	11295	30046	28.489999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1755.15	1761	1773	1703.1	1730.65	99718	1730.01	10957	34464	34.560001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1730.65	1733.75	1756	1721	1731.6	59434	1030.77	6523	21265	35.779998779296875
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1751.4	1734	1734	1665	1673.5	126856	2141.49	15892	63252	49.86000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1731.6	1747	1779	1723	1751.4	90457	1588	11821	27230	30.100000381469727
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	1835.95	1836.5	1840	1793.65	1804.9	150232	2715.49	10897	52208	34.75
Mon Sep 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	350	717	735	625	651.3	29189660	200259.84	704760	10910628	37.38
Tue Sep 22 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	651.3	664.7	703.9	635.85	694.25	6302385	42663.25	144003	903303	14.33
Wed Sep 23 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	ROUTE	694.25	714	833.1	708.15	824.25	14866529	115775.67	386411	1145456	7.7


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