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)	DHANI	153.3	151.8	160.9	150	153.5	25047752	39016.81	143934	5070578	20.239999771118164
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	153.5	153.55	158.45	151.5	156.25	9542465	14868.13	58374	2956430	30.979999542236328
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	156.25	157	158.25	147.05	149.95	7715280	11716.46	61326	2112283	27.3799991607666
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	149.95	151	151.7	144.15	148.65	4164916	6146.56	29012	1011519	24.290000915527344
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	140.95	139.5	143.95	138.7	140.15	5499195	7734.02	40732	2334204	42.45000076293945
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	148.65	148.95	149.05	139.55	140.95	8200723	11736.98	59348	3598636	43.880001068115234
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	134.4	135.3	156.7	132	153.3	105933075	152643.63	273010	46034400	43.459999084472656
Wed Oct 28 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	190.9	183.8	194.8	183.1	185.05	1166528	2173.99	7058	851809	73.02
Thu Oct 29 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	185.05	182.5	186.85	178.25	183.4	395548	720.83	4753	253484	64.08
Fri Oct 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DHANI	183.4	183	198.9	180.25	196.75	639872	1237.25	8532	265840	41.55


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