{
    "action": "tool_call",
    "reasoning": "Profile the raw table in one query for nulls, impossible OHLC relationships, non-positive values, zero volume, and ranges.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) n, COUNT(open) c_open, COUNT(high) c_high, COUNT(low) c_low, COUNT(close) c_close, COUNT(volume) c_vol, COUNT(date) c_date, COUNT(company_name) c_co, COUNT(stock_name) c_stk, COUNT(DISTINCT company_name) d_co, COUNT(DISTINCT stock_name) d_stk, SUM(CASE WHEN high < low THEN 1 ELSE 0 END) high_lt_low, SUM(CASE WHEN close > high OR close < low THEN 1 ELSE 0 END) close_outside, SUM(CASE WHEN open > high OR open < low THEN 1 ELSE 0 END) open_outside, SUM(CASE WHEN open<=0 OR high<=0 OR low<=0 OR close<=0 THEN 1 ELSE 0 END) nonpos_price, SUM(CASE WHEN volume<0 THEN 1 ELSE 0 END) neg_vol, SUM(CASE WHEN volume=0 THEN 1 ELSE 0 END) zero_vol, MIN(close) min_close, MAX(close) max_close, MEDIAN(close) med_close, MIN(volume) min_vol, MAX(volume) max_vol, MEDIAN(volume) med_vol, MIN(date) min_date, MAX(date) max_date, COUNT(DISTINCT _unnamed_0) d_idx FROM raw.semi_conductor_se",
        "purpose": "Profile nulls, impossible values, ranges",
        "source": "raw"
    }
}