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)	FEDERALBNK	101	101	101.2	98.25	98.9	9864599	9828.53	35932	2505633	25.399999618530277
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	98.9	99	100.5	97.8	99.5	24264144	24124.97	55680	13099985	53.9900016784668
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	99.5	99.85	100.05	97	99	9556428	9408.16	35131	1833799	19.190000534057617
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	99	99.7	103	99.7	102.15	22966546	23390.34	73588	6408046	27.899999618530277
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	104.45	103.9	106	102.3	102.95	28714979	30027.63	77259	10759472	37.470001220703125
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	102.15	102.5	105	100.9	104.45	30117303	31244.57	111002	10823596	35.939998626708984
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	101.4	101.25	101.9	100.8	101	10269350	10394.17	39698	3980011	38.7599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	87.95	88.25	89.25	88	88.75	5890570	5222.33	33326	1971963	33.48
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	88.75	88.55	92.8	88.55	92.25	13253695	12056.65	64431	4784111	36.1
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	FEDERALBNK	92.25	92	92.5	90.5	90.95	9418595	8601.88	40792	3342544	35.49


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