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)	YESBANK	13.45	13.6	13.85	13.55	13.7	102260941	14033.61	83758	39067724	38.20000076293945
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	13.7	13.9	14.15	13.7	13.95	107878882	15008.41	114357	42579088	39.470001220703125
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	13.95	14.05	14.25	14	14.15	148021736	20935.93	110541	59670656	40.310001373291016
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	14.15	14.25	14.35	14.05	14.1	68633731	9721.72	54843	25884320	37.709999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	13.85	13.85	14.2	13.75	13.9	105169399	14677.76	60949	32031664	30.459999084472656
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	14.1	14.15	14.2	13.8	13.85	65567550	9156.66	70100	30103544	45.90999984741211
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	13.65	13.65	13.7	13.35	13.45	59047564	7966.81	81781	20085246	34.02000045776367
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	46.95	46.95	47.5	46.5	46.65	102291841	47956.95	175825	9168235	8.96
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	46.65	46.8	48.5	46.4	47.35	122242838	57856.42	217958	14122071	11.55
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	YESBANK	47.35	47.35	48.25	46.85	47.1	94827592	44988.59	184973	13102728	13.82


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