<invoke name="tool_call"> <parameter name="reasoning">Check duplicate key rows, the 300000 max close outlier, and extreme daily jumps, which the profile doesn't cover.</parameter> <parameter name="tool">query_sql</parameter> <parameter name="args">{"sql":"WITH r AS (SELECT stock_name, company_name, date, open, high, low, close, volume, LAG(close) OVER (PARTITION BY stock_name ORDER BY date) AS prev_close FROM raw.semi_conductor_se), j AS (SELECT stock_name, date, close, prev_close, close/prev_close AS ratio FROM r WHERE prev_close > 0 AND (close/prev_close > 3 OR close/prev_close < 0.33)) SELECT 'dup_key_rows' AS check_name, CAST(COUNT(*) AS VARCHAR) AS detail, NULL AS d2, NULL AS d3 FROM (SELECT stock_name, date FROM raw.semi_conductor_se GROUP BY 1,2 HAVING COUNT(*)>1) UNION ALL SELECT 'top_close', stock_name, CAST(date AS VARCHAR), CAST(close AS VARCHAR) FROM (SELECT stock_name, date, close FROM raw.semi_conductor_se ORDER BY close DESC LIMIT 5) UNION ALL SELECT 'jump_gt3x_or_lt_third', stock_name, CAST(date AS VARCHAR), CAST(ROUND(ratio,3) AS VARCHAR) FROM (SELECT * FROM j ORDER BY ABS(LN(ratio)) DESC LIMIT 15) UNION ALL SELECT 'tickers_multi_company', stock_name, CAST(COUNT(DISTINCT company_name) AS VARCHAR), NULL FROM raw.semi_conductor_se GROUP BY stock_name HAVING COUNT(DISTINCT company_name)>1","purpose":"Find duplicate keys, extreme close values, and implausible day-over-day jumps plus ticker/company mapping inconsistencies","source":"raw"}</parameter> </invoke>