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)	GRINDWELL	1924.4	1900	1900	1792	1855.7	100211	1837.72	20378	52904	52.790000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1855.7	1853.95	1885.95	1797	1818.9	28741	524.43	7007	17774	61.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1818.9	1824	1824	1760	1785.9	38403	687.16	11280	27400	71.3499984741211
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1785.9	1793	1803.25	1711.65	1746.5	78508	1360.98	20094	47545	60.560001373291016
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1728.2	1719	1739.6	1662	1684.85	56835	957.08	10481	34965	61.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1746.5	1746	1763.9	1720	1728.2	32124	557.15	8034	19601	61.02000045776367
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	1948.9	1950	1950	1915	1924.4	27092	523.76	11127	16512	60.95000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	601.9	601.8	606.45	581.45	592.25	22242	132.11	1285	10299	46.3
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	592.25	587	597.05	585.5	593.85	15395	91.07	537	9122	59.25
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRINDWELL	593.85	591.05	615	590	597.2	15338	92.58	1559	9214	60.07


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