{
    "action": "tool_call",
    "reasoning": "My previous reply cited figures that are not in the evidence, so I'm discarding it. I'll start by profiling the raw table in one query: row count, tickers, date range, nulls, and pooled high-low range. Later claims can then be grounded in results I actually ran.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) AS n_rows, COUNT(DISTINCT company_name) AS n_companies, COUNT(DISTINCT stock_name) AS n_tickers, MIN(date) AS min_date, MAX(date) AS max_date, COUNT(close) AS close_nonnull, COUNT(volume) AS volume_nonnull, SUM(CASE WHEN volume = 0 THEN 1 ELSE 0 END) AS zero_volume_rows, SUM(CASE WHEN date >= DATE '2023-01-01' THEN 1 ELSE 0 END) AS rows_2023_on, AVG((high - low) / NULLIF(close, 0)) AS avg_range_pct, MEDIAN(volume) AS median_volume FROM raw.semi_conductor_se",
        "purpose": "Profile the table: size, coverage, nulls, post-2023 share, pooled daily range, and volume",
        "source": "raw"
    }
}