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)	GLENMARK	495.75	495.75	498.5	489.35	491	268817	1324.69	6556	87404	32.5099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	491	488.3	495.1	485.5	489.8	472247	2313.8	10249	159262	33.720001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	489.8	490	493.95	482.1	484.95	483382	2351.4	17083	123948	25.63999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	484.95	487.8	504.5	487.15	501.75	966188	4804.83	36866	282174	29.200000762939453
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	501.45	496	499.7	487	489.5	671404	3299.95	12295	187264	27.88999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	501.75	505	505	494.75	501.45	1329495	6626.64	18741	171886	12.93000030517578
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	502.9	503.9	504.75	492.55	495.75	325299	1624.24	7482	85356	26.239999771118164
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	347.45	347.7	350.35	345.1	345.7	596315	2069.99	7232	115401	19.35
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	345.7	346.1	356.8	344	353.9	1356814	4763.22	15672	378683	27.91
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GLENMARK	353.9	354	358.9	347.85	352.1	2502770	8846.08	37456	546871	21.85


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