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)	NMDC	153.95	154.4	155.45	152.6	153.4	12957277	19956.2	52916	5498142	42.43000030517578
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	153.4	153.9	155.95	152.5	153.95	11987318	18515.46	110538	6017821	50.20000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	153.95	154.5	155.35	150.35	153.4	12326734	18804.54	44416	5117481	41.52000045776367
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	153.4	153	157.65	152.8	155.7	17521097	27176.34	66157	7435561	42.43999862670898
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	159.3	158.9	161.4	157.1	158.15	15004288	23896.51	70616	6994853	46.619998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	155.7	156.25	160.5	156.1	159.3	18433104	29356.14	113401	8496700	46.09000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	150.5	150.75	154.95	149.8	153.95	26764867	41024.34	90102	9964288	37.22999954223633
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	128.9	129.05	129.7	127.15	128.35	2620422	3360.89	13284	496912	18.96
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	128.35	129.15	131.65	128.95	131.2	6159633	8027.29	26008	998476	16.21
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NMDC	131.2	131.5	131.5	128.4	129.25	4688896	6072.95	19558	2056579	43.86


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