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)	DCBBANK	87.3	87.3	88.7	87	87.45	780765	685.7	5149	425826	54.540000915527344
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	87.45	87	88.7	85.55	88.1	845959	743.36	11726	399989	47.27999877929688
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	88.1	88.5	88.7	86.05	88.2	722617	633.92	8067	416965	57.70000076293945
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	88.2	88.2	88.7	84.55	86.9	2761603	2387.65	23251	814379	29.489999771118164
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	84.8	84.75	86.25	84.45	84.8	766552	653.2	7054	351345	45.83000183105469
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	86.9	85.2	86	84.4	84.8	1572001	1338.57	10300	957944	60.93999862670898
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	87.15	87.2	88.4	86.25	87.3	678110	591.67	4285	376033	55.45000076293945
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	171.9	172.45	177.9	172	176.3	800357	1404.81	12378	404500	50.54
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	176.3	177	184.4	174.85	183.3	1236442	2235.55	19496	893177	72.24
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	DCBBANK	183.3	183.3	184	179.05	182.5	1481891	2672.97	13947	1083033	73.08


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