# Runnable EVM workflows

Each guide is a runnable notebook for a complete workflow. Run it as written, then change the SQL or inputs.

Canonical HTML: <https://determica.com/docs/guides>

- [Analyze ERC-20 transfers for a UTC day](/docs/guides/analyze-erc20-transfers-for-a-utc-day.md) — Fetch ERC-20 Transfer logs for one UTC day and query the decoded rows with SQL.
- [Compare Uniswap V3 and V4 routes](/docs/guides/compare-uniswap-v3-v4-routes.md) — Compare Uniswap V3, V4, and split ETH → USDC routes at one pinned block. Simulate family leaders, rank after gas, and inspect every check and rejection reason.
- [Query contract state with SQL](/docs/guides/query-contract-state-with-sql.md) — Call an EVM contract function from SQL, pin the read to one block, and use a column as the function argument.