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)	IDFC	66.6	66.15	67.4	65.25	66.25	11550815	7656.51	15638	2491375	21.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	66.25	66.4	66.65	64	65.1	6908401	4503.8	13549	1427968	20.670000076293945
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	65.1	65.5	65.55	62.3	64	9687085	6158.53	16079	3402517	35.119998931884766
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	64	64.5	65.4	63.85	65.1	5576636	3605.12	14576	1835722	32.91999816894531
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	65.95	65.45	65.7	63.25	63.65	11304410	7285.72	23275	2685913	23.76000022888184
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	65.1	65.25	66.35	64.4	65.95	7989027	5240.26	14536	2385623	29.86000061035156
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	67.6	67.4	67.6	66.35	66.6	8725868	5830.56	17490	3076638	35.2599983215332
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	39.25	39.25	39.6	38.65	38.85	1579649	617.34	5836	684705	43.35
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	38.85	38.5	39	37.9	38.05	2729905	1043.49	11940	1635068	59.89
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	IDFC	38.05	38.1	38.1	37.1	37.2	1790873	672.94	11274	843357	47.09


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