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)	WOCKPHARMA	394.15	396	398.15	391.7	394.9	244136	963.71	11290	96790	39.650001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	394.9	394	395.75	386	388.3	246906	961.71	6718	103305	41.84000015258789
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	388.3	405	408.6	392.95	394.3	916486	3662.28	22873	185605	20.25
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	394.3	395.1	397	388.35	390.7	226175	886.78	6956	87973	38.900001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	398.7	395	420.3	395	412.55	1161015	4783.93	28300	451348	38.880001068115234
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	390.7	390.8	403.2	388.95	398.7	428509	1690.88	9512	164153	38.310001373291016
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	397.5	399.6	400.9	392.65	394.15	265010	1048.17	6766	108734	41.02999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	233.95	235.6	236.8	232	235	532364	1249.34	8367	107072	20.11
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	235	235.05	239.9	235	237.7	638193	1518.86	8715	182963	28.67
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	WOCKPHARMA	237.7	238.7	248.8	237	242.25	1878058	4581.81	23169	410918	21.88


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