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)	RBLBANK	153.55	154.5	155.4	148.65	149.65	13767817	20829.75	59650	1977783	14.369999885559082
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	149.65	149.5	150.5	145.2	146.25	11632649	17172.93	45502	1747792	15.020000457763672
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	146.25	147.1	147.65	139.6	144.65	15689705	22472.81	76119	2251318	14.350000381469728
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	144.65	147	147.5	143.6	146.3	7830501	11379.75	37253	957455	12.229999542236328
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	146.4	145	147	141.2	141.8	8175335	11744.16	38170	1521428	18.61000061035156
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	146.3	147.05	148.7	145.55	146.4	6735909	9897.69	32826	733604	10.890000343322754
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	154.7	153.9	155.75	151.5	153.55	12404391	19073.57	57609	1543683	12.4399995803833
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	344.85	346	351	345	347.95	7055518	24555.35	54178	721791	10.23
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	347.95	347	372.4	345	369.55	13364375	48060.69	102340	1569748	11.75
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	RBLBANK	369.55	367	367.9	355.75	357.6	9763249	35241.84	82455	1081059	11.07


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