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)	EQUITASBNK	57.6	57.7	58.4	57.2	57.85	265731	153.52	2859	148845	56.0099983215332
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	57.85	57.9	58.1	56.5	56.85	187286	106.82	2755	109954	58.709999084472656
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	56.85	56.6	57.15	55.3	55.8	179839	100.76	2833	80925	45
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	55.8	56.4	56.65	55.6	56.15	209591	117.68	2290	107856	51.459999084472656
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	56.75	56.5	57.45	55.6	56.45	281013	158.78	3451	155044	55.16999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	56.15	56.5	57.6	56	56.75	204880	116.1	2474	132615	64.7300033569336
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	57.25	57.95	58.35	57.35	57.6	390512	225.6	3508	229518	58.77000045776367
Mon Nov 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	33	31.1	33.15	30.05	32.8	23099679	7316.37	81782	7544863	32.66
Tue Nov 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	32.8	33.15	33.75	32.7	32.95	4556016	1503.49	13429	2733118	59.99
Wed Nov 04 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	EQUITASBNK	32.95	32.95	33.1	32	32.7	1667520	547.17	8244	1256072	75.33


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