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)	BANKBARODA	109.55	109.8	111.35	106.15	106.55	45581685	49480.39	111014	8782770	19.270000457763672
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	106.55	108.8	117.2	108.25	112.95	177298544	201471.56	403124	32211532	18.170000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	112.95	114	118.3	111.5	117.95	115380004	133166.46	270430	15900103	13.779999732971191
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	117.95	118.5	118.8	114.5	114.85	61784484	71465.39	163242	13760566	22.270000457763672
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	114.7	113.7	115.45	112.5	113.55	33757340	38550.94	89892	7225195	21.399999618530277
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	114.85	115.4	116.4	113.6	114.7	40178477	46236.29	110555	6175878	15.369999885559082
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	109.4	109.1	111.9	108.5	109.55	54520992	60094.48	131182	12832137	23.540000915527344
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	101.9	102.25	102.7	101.3	101.9	12896434	13145.09	27102	1106315	8.58
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	101.9	102.1	104.85	101.75	104.45	18704405	19319.88	42432	2480926	13.26
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANKBARODA	104.45	103.95	103.95	100.1	100.85	24439056	24910.66	55406	4308223	17.63


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