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)	IRFC	23.2	23.2	23.3	23	23.05	5329628	1230.7	13566	3424436	64.25
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23.05	23.1	23.15	23	23.05	5132340	1183.35	12963	2835310	55.2400016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23.05	23.1	23.15	22.9	23	5051898	1162.67	11234	2439409	48.290000915527344
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23	23.05	23.15	23	23.05	3686570	849.67	9298	2180503	59.150001525878906
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23.15	23.15	23.2	22.9	22.95	7856571	1806.65	13753	4126347	52.52000045776367
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23.05	23.15	23.5	23.05	23.15	9814830	2276.58	12399	3543415	36.09999847412109
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	23.25	23.25	23.35	23.15	23.2	4151889	964.53	11807	2134256	51.400001525878906
Fri Jan 29 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	26	24.9	25.8	24.35	24.8	381938573	95788.17	496815	202093230	52.91
Mon Feb 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	24.8	25.25	25.4	24.9	25.1	72044464	18103.82	153055	36416300	50.55
Tue Feb 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	IRFC	25.1	25.45	25.45	24.7	24.75	36735442	9176.4	102457	23249200	63.29


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