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)	GUJGASLTD	678.6	679	692	667.2	681.25	882512	6029.29	19632	325314	36.86000061035156
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	681.25	681.35	697.65	675	690.35	663128	4564.66	27333	291243	43.91999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	690.35	692.5	695.9	660.65	664.85	898537	6026.73	30028	282512	31.440000534057617
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	664.85	626	674	625	660.7	4576490	29883.43	115990	1050306	22.950000762939453
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	647.65	641	651	633	637.45	978809	6243.66	22365	364515	37.2400016784668
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	660.7	658	659.1	641.55	647.65	1278455	8286.25	31963	485173	37.95000076293945
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	693.4	695.05	698.7	675.3	678.6	631797	4341.31	12476	354696	56.13999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	237.55	239	257.4	237.85	254.7	3384760	8467.34	46994	573514	16.94
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	254.7	255.5	270	248.1	255.05	3889732	10088.6	69575	1228341	31.58
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GUJGASLTD	255.05	255	260	249	250.65	2695895	6782.13	32589	1857780	68.91


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