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)	20MICRONS	90.6	91.6	91.8	87.55	88.15	224694	200.24	3029	129640	57.70000076293945
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	21STCENMGM	42.05	41.25	41.25	41.25	41.25	7983	3.29	58	7983	100
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3IINFOLTD	76.9	76.35	77.45	75.8	76	448661	342.69	5607	319234	71.1500015258789
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3MINDIA	24868.65	24620	24806.1	24551.1	24744.3	1695	418.2	428	1304	76.93000030517578
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	3PLAND	19.6	20.5	20.55	20.5	20.55	9816	2.02	79
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	5PAISA	399.4	407	407	395	396.55	24080	96.08	1339	14468	60.08000183105469
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	63MOONS	302.3	315	317.4	288	294.1	199401	604.51	3385
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	A2ZINFRA	11.8	11.55	11.7	11.25	11.45	1370916	156.17	1356	725940	52.95000076293945
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAKASH	31.05	31.35	33.8	31.35	33.6	1775910	581.91	5244	715300	40.27999877929688
Fri Feb 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	AAREYDRUGS	52.55	52.4	54.9	52.15	53.15	66752	35.57	872	38946	58.34000015258789


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