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)	BANDHANBNK	324.25	326.4	329	318.4	319.4	5051213	16316.69	48773	1755416	34.75
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	319.4	320	325.9	315.65	320.75	5473093	17532.46	52112	1738055	31.76000022888184
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	320.75	321	325.75	315	319.15	4676458	15006.55	45965	969271	20.729999542236328
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	319.15	320.7	326.55	319	321.2	2541512	8181.09	26171	562382	22.1299991607666
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	321.45	320.9	326.8	314.4	317.85	7932739	25476.2	72249	2764451	34.849998474121094
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	321.2	322.7	324	317.25	321.45	4107513	13217.89	51835	1729056	42.09000015258789
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	320.55	321	330.7	319.75	324.25	8925674	29132.8	87809	2427846	27.200000762939453
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	508.25	510.8	511.75	501	503	520264	2629.82	13964	190947	36.7
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	503	502.95	502.95	495.25	499	1835744	9140.64	33213	1283398	69.91
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	BANDHANBNK	499	496	514.7	496	506.15	1466650	7442.53	41117	802203	54.7


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