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)	GRASIM	1732.7	1732.7	1765	1727.2	1735.3	569416	9945.8	41252	156849	27.549999237060547
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1735.3	1725.05	1749.65	1700	1712.35	481298	8269.22	26684	111494	23.170000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1712.35	1721.35	1728	1685.4	1717.8	421620	7202.78	34137	140627	33.349998474121094
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1717.8	1718.1	1746	1713	1739.7	454006	7872.14	36510	141820	31.239999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1768.55	1750	1760	1702	1710.15	983623	16891.58	64620	379454	38.58000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1739.7	1726.6	1771.3	1726.6	1768.55	622393	10954.34	80064	241372	38.77999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	1778.1	1779.05	1786	1722	1732.7	480434	8445.39	31666	151523	31.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	743.65	746.8	747.4	738.6	742.5	685313	5090.74	11402	47464	6.93
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	742.5	742	768.5	741	766.35	2413731	18321.55	35565	415238	17.2
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GRASIM	766.35	769.95	769.95	751.5	756.65	1411458	10721.52	24417	283619	20.09


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