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)	GAEL	203.4	203.4	207.8	200.8	202.5	497922	1018.18	9910	195011	39.15999984741211
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	202.5	202.9	204.5	193	194.55	465702	921.02	9046	220037	47.25
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	194.55	196.1	198.5	187.15	196.6	513165	996.99	9219	153284	29.8700008392334
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	196.6	198.2	198.65	190.15	192	295074	572.28	6635	124875	42.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	190.05	187.1	192.05	184	186	306330	577.49	5754	111578	36.41999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	192	192	195.6	189	190.05	415863	799.43	8688	149066	35.84000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	197.9	200.2	207	200.2	203.4	906294	1848.46	13743	308075	33.9900016784668
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	133.05	134.95	136.35	130	131.5	43154	57.02	617	24989	57.91
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	131.5	132.9	140.95	131	138.2	108185	147.86	1864	60613	56.03
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	GAEL	138.2	137.05	143.9	137.05	139.25	68311	96.06	2211	44860	65.67


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