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)	GAIL	147.4	149.75	151.95	146.15	146.55	18772221	27957.34	98985	6288707	33.5
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	146.55	147.45	148.9	146.4	148.25	8159964	12078.34	40663	4175364	51.16999816894531
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	148.25	148.35	148.8	142.3	144.3	12055244	17384.87	65978	5576905	46.2599983215332
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	144.3	145	145.6	142.3	142.95	7631688	10976.62	49157	4254042	55.7400016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	141.6	140.7	142.75	140	140.65	7733105	10930.99	38563	4280961	55.36000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	142.95	143.4	143.45	140.35	141.6	20379088	28897.9	94182	13507775	66.27999877929688
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	145.7	145	149.3	145	147.4	16096878	23691.83	80157	4771253	29.63999938964844
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	121.05	121.4	121.8	119.75	121.2	4704499	5677.9	26255	951936	20.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	121.2	121.5	123.95	120.65	123.55	6747917	8273.16	34471	2318282	34.36
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAIL	123.55	123.7	128.8	123.7	125.65	21625485	27361.98	86172	8294359	38.35


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