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)	NBCC	46.8	47.1	47.1	45.8	46.05	4641879	2159.53	12653	2269844	48.900001525878906
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	46.05	45.85	46.15	45.3	45.45	2554501	1165.54	11995	1112255	43.540000915527344
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	45.45	45.45	45.7	44.35	44.95	3320982	1494.13	13718	1014241	30.540000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	44.95	45	45.85	44.95	45.7	2608170	1183.25	9620	1062413	40.72999954223633
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	45.95	45.2	45.8	44.6	44.8	3026842	1366.12	12284	1419192	46.88999938964844
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	45.7	45.9	46.1	45.2	45.95	2671972	1220.98	11891	1128043	42.220001220703125
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	47.35	47.65	47.7	46.6	46.8	4013257	1890.49	12280	1518423	37.84000015258789
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	34.85	34.95	35.15	34.35	34.7	8284763	2875.96	11037	1157217	13.97
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	34.7	34.65	38.15	34.4	37.4	27183282	9935.12	35296	6839519	25.16
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	NBCC	37.4	37.3	38	36.65	36.9	21050255	7843.37	30832	2847984	13.53


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