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)	ATGL	1851.65	1868	1870	1830	1851.1	235782	4390.53	3242
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1851.1	1876	1879	1801	1820.15	76636	1401.33	4228
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1820.15	1820.15	1835	1780	1809.05	81276	1472.29	4616
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1809.05	1805	1821	1750	1765	255476	4613.27	3808
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1810.55	1796.9	1799	1731	1790.3	292368	5211.95	7535
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1765	1769	1830	1676.75	1810.55	347972	6225.4	10218
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	1877.1	1845	1869.95	1783.25	1851.65	258851	4783.45	3543
Wed Jan 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	365.9	367.3	369.9	355.1	363.8	1171644	4275.27	10711	803045	68.54
Thu Jan 14 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	363.8	364.6	364.6	353	361.1	949106	3418.39	9433	778467	82.02
Fri Jan 15 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	ATGL	361.1	360.5	368	357.35	359.95	1026453	3717.67	10294	805132	78.44


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