{
    "action": "tool_call",
    "reasoning": "Profile the dataset's scope in one query to ground the analysis: rows, companies, tickers, date range, average volume, median close, post-ChatGPT rows, zero-volume rows.",
    "tool": "query_sql",
    "args": {
        "sql": "SELECT COUNT(*) AS n_rows, COUNT(DISTINCT company_name) AS companies, COUNT(DISTINCT stock_name) AS tickers, MIN(date) AS first_day, MAX(date) AS last_day, AVG(volume) AS avg_volume, MEDIAN(close) AS median_close, SUM(CASE WHEN date >= DATE '2022-11-30' THEN 1 ELSE 0 END) AS rows_since_chatgpt, SUM(CASE WHEN volume = 0 OR volume IS NULL THEN 1 ELSE 0 END) AS zero_volume_rows FROM raw.semi_conductor_se",
        "purpose": "Profile the dataset's scope (rows, companies, date range, volume) to ground the analysis",
        "source": "raw"
    }
}