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)	UNIONBANK	47.95	48.2	48.95	47.35	48	20089680	9668.87	27829	7149243	35.59000015258789
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	48	48.5	51.7	47.25	47.6	55308930	27373.8	80451	17692164	31.989999771118164
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	47.6	48.25	48.5	46.1	47.7	26137028	12334.87	40697	6822183	26.100000381469727
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	47.7	48	48.25	46.9	47.2	8614489	4084.23	16938	2439350	28.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	47.15	46.65	47.2	46.1	46.3	7388833	3445.65	13752	2647880	35.84000015258789
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	47.2	47.5	47.85	46.15	47.15	13125342	6196.18	22388	3222158	24.549999237060547
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	49.8	50.25	50.8	47.65	47.95	37000818	18255.02	54131	14558441	39.34999847412109
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	54.8	55.05	55.6	54.15	54.55	4807629	2638.7	11001	980030	20.38
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	54.55	54.45	55.45	54.45	55.15	5754393	3170.66	12002	1709886	29.71
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	UNIONBANK	55.15	55.1	55.5	54.35	54.75	5525524	3035.3	12305	1132861	20.5


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