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)	SYMPHONY	989.2	1004.8	1004.8	984.05	994.05	26831	267.05	3116	10616	39.56999969482422
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	994.05	999.85	1004.25	981.45	988	17822	176.9	2275	8701	48.81999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	988	999.8	1000	982.15	997.6	16841	167.14	2356	7466	44.33000183105469
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	997.6	997.6	1004	990.1	994.9	11304	112.65	1733	5890	52.11000061035156
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	995.05	990	1005	986.7	994.75	22254	222.25	2716	11544	51.869998931884766
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	994.9	999.8	1001.3	990.2	995.05	13534	134.81	1833	8354	61.72999954223633
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	1002.75	1005	1008.65	986	989.2	127954	1267.49	5485	113254	88.51000213623047
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	1162.45	1170	1170.2	1145	1148.55	10150	116.83	1018	7350	72.41
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	1148.55	1145.05	1159.95	1121.15	1131.8	19379	220.82	1636	11682	60.28
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SYMPHONY	1131.8	1137.65	1154.85	1137	1147.5	16602	189.94	2167	10952	65.97


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