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)	SOLARINDS	2339.9	2346	2353.15	2311	2330.65	12233	285.32	2401	6212	50.77999877929688
Mon Feb 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2330.65	2330.65	2397.95	2324.55	2339.7	14157	332.66	3820	5531	39.06999969482422
Tue Feb 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2339.7	2359.7	2415	2334.1	2355.45	55983	1327.07	11982	21053	37.61000061035156
Wed Feb 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2355.45	2376.7	2384.45	2315.45	2337.35	26883	628.49	3036	20518	76.31999969482422
Fri Feb 11 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2285.4	2296.85	2296.85	2245.4	2262.85	63818	1449.17	3752	53892	84.44999694824219
Thu Feb 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2337.35	2330	2337	2264	2285.4	39893	922.54	3422	31347	78.58000183105469
Thu Feb 03 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	2331.85	2329.7	2357.95	2321.25	2339.9	57878	1354.54	3987	39227	67.77999877929688
Wed Jan 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	1060.35	1060	1076	1060	1070.7	2091	22.4	251	1290	61.69
Thu Jan 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	1070.7	1079	1125.05	1066.6	1097.15	14707	160.83	1240	12058	81.99
Fri Jan 03 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	SOLARINDS	1097.15	1119	1120.1	1100.2	1118.35	19915	221.82	907	14974	75.19


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