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)	DELTACORP	288.15	289.9	293.7	284.55	285.6	3498000	10121.58	22515	461592	13.199999809265137
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	285.6	286.9	291.3	281.05	282.7	2783878	7965.2	21216	458930	16.489999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	282.7	283.95	285.5	271.15	278.5	2940736	8158.85	23460	387702	13.18000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	278.5	278.95	285.9	278.95	284.75	2379062	6743.93	18712	564745	23.739999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	288.25	285	285.7	276.8	278.15	2875657	8079.96	23329	546227	18.989999771118164
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	284.75	286	290	283.25	288.25	2392907	6855.33	17827	489891	20.46999931335449
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	287.55	289	294.7	286	288.15	3782701	11004.92	33917	612956	16.200000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	198.05	199	199.2	194.35	194.8	530544	1041.06	6792	223819	42.19
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	194.8	195.2	203	195.2	201.2	1166717	2323.33	13679	443552	38.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DELTACORP	201.2	201	205	193	193.9	1281472	2541.64	15094	523497	40.85


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