{
    "action": "tool_call",
    "reasoning": "Close is the core price measure. Query the top 5 and bottom 5 close records using a WITH clause so the query is valid.",
    "tool": "query_sql",
    "args": {
        "sql": "WITH hi AS (SELECT 'highest' AS rank_type, company_name, stock_name, date, open, high, low, close, volume FROM raw.semi_conductor_se WHERE close IS NOT NULL ORDER BY close DESC LIMIT 5), lo AS (SELECT 'lowest' AS rank_type, company_name, stock_name, date, open, high, low, close, volume FROM raw.semi_conductor_se WHERE close IS NOT NULL ORDER BY close ASC LIMIT 5) SELECT * FROM hi UNION ALL SELECT * FROM lo",
        "purpose": "Top 5 and bottom 5 close records",
        "source": "raw"
    }
}