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)	THERMAX	2036.15	2025.25	2066	1960.8	2008.1	48143	967.66	9808	14544	30.209999084472656
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	2008.1	2040	2066	1965.65	2037.55	99727	2032.13	17446	28606	28.68000030517578
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	2037.55	2053	2063.1	1940	1953.65	92834	1834.07	14360	39849	42.93000030517578
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1953.65	1989.95	2002.9	1905	1977.3	93542	1818.52	14460	40211	42.9900016784668
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1926.85	1909	1910.7	1850	1859.35	102067	1910.15	13831	62308	61.04999923706055
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1977.3	1979.95	1984.05	1911.1	1926.85	40945	791.54	7555	16412	40.08000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	2062.35	2064	2089	2030.05	2036.15	60131	1231.03	9721	15629	25.989999771118164
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1082.6	1086.65	1119.9	1085.5	1116.55	28908	320.61	2938	14424	49.9
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1116.55	1119	1119	1081.9	1099.3	55451	614.05	7134	34391	62.02
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	THERMAX	1099.3	1090	1109	1080	1093.05	43906	479.93	3012	30138	68.64


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