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)	CHAMBLFERT	407.1	404.9	409.7	395.4	396.95	1596208	6397.98	32078	429227	26.88999938964844
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	396.95	396	404.85	392.65	395.2	1574930	6296.58	41032	378598	24.040000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	395.2	397	399.7	384.1	390.35	1337881	5223.44	34302	294483	22.01000022888184
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	390.35	391.95	405.95	391.5	404.1	1796604	7217.46	34442	456043	25.3799991607666
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	407.45	404.5	406.45	385.9	387.9	1323563	5214.83	25623	464697	35.11000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	404.1	405	409.4	402.1	407.45	1249509	5085.06	22936	429015	34.33000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	403.5	404.2	415.85	404	407.1	2096846	8611.01	38342	478836	22.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	152.25	152.8	153.9	152	153.1	406099	620.42	1980	341003	83.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	153.1	153.65	156.95	152.25	154.4	681716	1054	4641	365465	53.61
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	CHAMBLFERT	154.4	154.7	157.75	152.65	153.5	840451	1295.1	5259	550128	65.46


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