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)	IDFCFIRSTB	48.4	48.4	48.7	47.6	47.9	17505548	8419.51	25819	4632971	26.46999931335449
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	47.9	47.9	48.15	46.6	47.1	16712886	7917.93	30898	3946845	23.6200008392334
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	47.1	47.2	47.45	45.9	46.75	19087389	8886.95	31188	4416701	23.13999938964844
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	46.75	47.05	47.4	46.65	47.1	9817874	4615.29	18455	2805506	28.57999992370605
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	47.25	47	47.4	46.35	46.45	18679632	8730.19	24781	6288823	33.66999816894531
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	47.1	47.3	47.8	46.75	47.25	12999351	6150.14	25116	2971866	22.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	49.3	49.3	49.4	48.2	48.4	19239520	9381.9	31676	5373007	27.93000030517578
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	45.15	45.35	45.95	44.95	45.8	12581227	5726.91	21737	4408974	35.04
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	45.8	46	46.55	45.5	46.15	16903047	7773.49	32986	7352857	43.5
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFCFIRSTB	46.15	46.1	46.5	45.15	45.45	14646549	6703.47	27108	5635826	38.48


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