<invoke name="query_sql"> <parameter name="sql">SELECT COUNT(*) AS n, COUNT(DISTINCT stock_name) AS stocks, COUNT(DISTINCT company_name) AS companies, SUM(CASE WHEN high < low THEN 1 ELSE 0 END) AS high_lt_low, SUM(CASE WHEN close > high OR close < low THEN 1 ELSE 0 END) AS close_outside, SUM(CASE WHEN open > high OR open < low THEN 1 ELSE 0 END) AS open_outside, SUM(CASE WHEN volume = 0 THEN 1 ELSE 0 END) AS zero_vol, SUM(CASE WHEN open <= 0 OR close <= 0 THEN 1 ELSE 0 END) AS nonpos, SUM(CASE WHEN high = low THEN 1 ELSE 0 END) AS flat_days, MIN(close) AS min_close, MAX(close) AS max_close, MAX(volume) AS max_vol, COUNT(*) - COUNT(DISTINCT stock_name || CAST(date AS VARCHAR)) AS dup_keys FROM raw.semi_conductor_se</parameter> <parameter name="purpose">Profile data integrity anomalies and scale</parameter> </invoke>