Make EVM state and execution queryable.

WITH requests AS (
  SELECT
    COALESCE(purchased_at::VARCHAR, 'day1') AS source_id,
    MIN(purchased_at) AS purchased_at,
    SUM(parse_units('200', 6)) AS amount_in_raw
  FROM generate_series(
    TIMESTAMP '2025-08-01 00:00:00',
    TIMESTAMP '2026-07-01 00:00:00',
    INTERVAL 1 MONTH
  ) AS months(purchased_at)
  GROUP BY ROLLUP (purchased_at)
),
quotes AS (
  SELECT
    r.source_id,
    r.purchased_at,
    r.amount_in_raw,
    decoded.amountOut AS amount_out_raw,
    muldiv(r.amount_in_raw, parse_units('1', 30), decoded.amountOut) AS price_raw,
    SUM(decoded.amountOut) FILTER (WHERE source_id <> 'day1') OVER (ORDER BY purchased_at) AS total_out_raw,
    MAX(decoded.amountOut) FILTER (WHERE source_id = 'day1') OVER () AS day_one_out_raw
  FROM read_contract_multicall((
    SELECT
      source_id,
      $client AS client,
      $quoter AS to_address,
      encode_function_data(
        $quoter_v2_abi,
        'quoteExactInputSingle',
        struct_pack(
          tokenIn := $usdc,
          tokenOut := $weth,
          amountIn := amount_in_raw,
          fee := 500,
          sqrtPriceLimitX96 := 0
        )
      ) AS call_data,
      block_at($client, purchased_at) AS block_number
    FROM requests
  )) raw
  CROSS JOIN LATERAL call_decode(
    $quoter_v2_abi, 'quoteExactInputSingle', return_data
  ) decoded
  JOIN requests r USING (source_id)
  WHERE ok AND call_success
)
SELECT
  purchased_at AS quoted_at,
  format_units(price_raw, 18)::DOUBLE AS quote_price_usdc_per_weth,
  format_units(amount_in_raw, 6)::DOUBLE AS usdc_input,
  format_units(amount_out_raw, 18)::DOUBLE AS weth_quoted,
  format_units(total_out_raw, 18)::DOUBLE AS cumulative_weth_quoted,
  format_units(day_one_out_raw, 18)::DOUBLE AS day_one_weth_quoted
FROM quotes
WHERE source_id <> 'day1'
ORDER BY purchased_at;