Determica | EVM execution and analysis with SQL

Compare 12 monthly quotes with one day-one quote.

Run a set of quotes against historical Ethereum blocks, then filter, aggregate, or join the returned rows in the notebook.

Monthly quotes: 0.92777 WETH; 12 × 200 USDC · Aug ’25–Jul ’26
Day-one quote: 0.64902 WETH; 2,400 USDC · Aug 1, 2025
Quote difference: +0.27874 WETH; +42.9% versus day one

This compares historical quote outputs, not actual trades. Gas costs are not included.

WETH quoted each month

Monthly quotes overtake the day-one quote in May ’26

{"id":"uniswap-v3-dca","title":"Quote monthly USDC inputs and one day-one total","code":"WITH requests AS (\n SELECT\n COALESCE(purchased_at::VARCHAR, 'day1') AS source_id,\n MIN(purchased_at) AS purchased_at,\n SUM(parse_units('200', 6)) AS amount_in_raw\n FROM generate_series(\n TIMESTAMP '2025-08-01 00:00:00',\n TIMESTAMP '2026-07-01 00:00:00',\n INTERVAL 1 MONTH\n ) AS months(purchased_at)\n GROUP BY ROLLUP (purchased_at)\n),\nquotes AS (\n SELECT\n r.source_id,\n r.purchased_at,\n r.amount_in_raw,\n decoded.amountOut AS amount_out_raw,\n muldiv(r.amount_in_raw, parse_units('1', 30), decoded.amountOut) AS price_raw,\n SUM(decoded.amountOut) FILTER (WHERE source_id \u003c> 'day1') OVER (ORDER BY purchased_at) AS total_out_raw,\n MAX(decoded.amountOut) FILTER (WHERE source_id = 'day1') OVER () AS day_one_out_raw\n FROM read_contract_multicall((\n SELECT\n source_id,\n $client AS client,\n $quoter AS to_address,\n encode_function_data(\n $quoter_v2_abi,\n 'quoteExactInputSingle',\n struct_pack(\n tokenIn := $usdc,\n tokenOut := $weth,\n amountIn := amount_in_raw,\n fee := 500,\n sqrtPriceLimitX96 := 0\n )\n ) AS call_data,\n block_at($client, purchased_at) AS block_number\n FROM requests\n )) raw\n CROSS JOIN LATERAL call_decode(\n $quoter_v2_abi, 'quoteExactInputSingle', return_data\n ) decoded\n JOIN requests r USING (source_id)\n WHERE ok AND call_success\n)\nSELECT\n purchased_at AS quoted_at,\n format_units(price_raw, 18)::DOUBLE AS quote_price_usdc_per_weth,\n format_units(amount_in_raw, 6)::DOUBLE AS usdc_input,\n format_units(amount_out_raw, 18)::DOUBLE AS weth_quoted,\n format_units(total_out_raw, 18)::DOUBLE AS cumulative_weth_quoted,\n format_units(day_one_out_raw, 18)::DOUBLE AS day_one_weth_quoted\nFROM quotes\nWHERE source_id \u003c> 'day1'\nORDER BY purchased_at;","description":"ADDRESS parameters become ABI calls at historical BLOCK_NUMBER values. UINT256 amounts stay exact through aggregation and are formatted only in the final result.","resultTableName":"homepage_uniswap_v3_dca"}

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;

1 ETH baseline

$1,902.45 / ETH

32 ETH selected

$1,889.88 / ETH

Impact vs 1 ETH

−66.1 bps

Average execution price by trade size

Each bar is one independent simulation. Differences use the 1 ETH result as the baseline.

Selected input

32 ETH

Observed output

60,476 USDC

Execution gas

130,153

Execution status

SUCCESS

Succeeded

Saved resultEvidence complete

Execution ID

Program call

SenderSimulated senderTargetRouter02

Native value sent

Chain: Ethereum Mainnet
Chain ID
Block
Block hash

Steps
Total EVM execution gas
Transaction gas estimate
Gas status: complete_program

Candidate key

#0balanceSimulated starting balanceexact trade size funded

These overrides define the simulated world. They are inputs to this execution, not observations of upstream chain truth.

· ETH balance
· USDC

Native call valuecommitted
Router02 WETH
ETH · exact native base-unit claim · frame · log
Native call valuecommitted
Simulated sender Router02
ETH · exact native base-unit claim · frame · log
Decoded logcommitted
Router02 Uniswap V2 Pair
WETH · · frame · log
Decoded logcommitted
Uniswap V2 Pair Simulated sender
USDC · · frame · log

Step execute_callRouter02SUCCESS

fromSimulated sender· Native value sent· Total EVM execution gas· Transaction gas estimate

callRouter02.swapExactETHForTokens
Inclusive frame gasSUCCEEDED
Disposition committedfrom Simulated senderFrame message value
1. callUniswap V2 Pair.getReserves
  Inclusive frame gasSUCCEEDED
  Disposition committedfrom Router02Frame message value
2. callWETH.deposit
  Inclusive frame gasSUCCEEDED
  Disposition committedfrom Router02Frame message value
3. callWETH.transfer
  Inclusive frame gasSUCCEEDED
  Disposition committedfrom Router02Frame message value
4. callUniswap V2 Pair.swap
  Inclusive frame gasSUCCEEDED
  Disposition committedfrom Router02Frame message value
  1. callUSDC.transfer
    Inclusive frame gasSUCCEEDED
    Disposition committedfrom Uniswap V2 PairFrame message value
    1. delegatecallUSDC.transfer
      Inclusive frame gasSUCCEEDED
      Disposition committedfrom Uniswap V2 Pairvia USDC implementationFrame message value
  2. callUSDC.balanceOf
    Inclusive frame gasSUCCEEDED
    Disposition committedfrom Uniswap V2 PairFrame message value
    1. delegatecallUSDC.balanceOf
      Inclusive frame gasSUCCEEDED
      Disposition committedfrom Uniswap V2 Pairvia USDC implementationFrame message value
  3. callWETH.balanceOf
    Inclusive frame gasSUCCEEDED
    Disposition committedfrom Uniswap V2 PairFrame message value

{"id":"trade-size-outcomes","title":"Compare 32 trade-size outcomes","code":"-- Publish execution evidence before reading it below.\nWITH anchor AS MATERIALIZED (\n -- Resolve the finalized pin once, then share its number and hash across all candidates.\n SELECT pin($client, 'finalized') AS client\n),\nexecutions AS MATERIALIZED (\n SELECT\n e.execution_id,\n e.candidate_key,\n e.status\n FROM run((\n SELECT\n a.client,\n amount_in_raw::VARCHAR AS candidate_key,\n program(\n [assume_native_balance($sender, amount_in_raw, 'exact trade size funded')],\n [execute_contract(\n $sender,\n $router,\n amount_in_raw,\n 500000, -- Simulation ceiling; this is not a transaction gas limit.\n $router_abi,\n 'swapExactETHForTokens',\n 0,\n [$weth, $usdc],\n $sender,\n 9999999999 -- Far-future deadline for simulation only; never broadcast.\n )]\n ) AS program,\n [\n observation_fact($sender, 'Simulated sender'),\n observation_fact($router, 'Router02'),\n observation_fact($usdc, 'USDC'),\n observe('ETH', native_balance($sender)),\n observe('USDC', read_contract($usdc, $erc20_abi, 'balanceOf', $sender))\n ] AS observations\n FROM (\n SELECT\n candidate_index * $trade_size_step_wei AS amount_in_raw\n FROM range(1, 33) AS sizes(candidate_index)\n )\n CROSS JOIN anchor AS a\n )) AS e\n)\nSELECT\n format_ether(r.candidate_key::UINT256) AS amount_in_eth,\n format_units(o.delta_magnitude, 6) AS amount_out_usdc,\n format_units(\n muldiv(\n o.delta_magnitude,\n parse_ether('1'),\n r.candidate_key::UINT256\n ),\n 6\n ) AS average_price_usdc_per_eth,\n execution_evidence(r.execution_id) AS execution_evidence\nFROM executions AS r\nLEFT JOIN evm.execution_observation_pairs AS o\n ON o.execution_id = r.execution_id\n AND o.observation_key = 'USDC'\n AND r.status = 'success'\n AND o.delta > 0::INT512\nORDER BY r.candidate_key::UINT256;","resultTableName":"homepage_trade_size_outcomes"}

-- Publish execution evidence before reading it below.

WITH anchor AS MATERIALIZED (

-- Resolve the finalized pin once, then share its number and hash across all candidates.

SELECT pin($client, 'finalized') AS client

executions AS MATERIALIZED (

SELECT

e.execution_id,

e.candidate_key,

e.status

FROM run((

SELECT

a.client,

amount_in_raw::VARCHAR AS candidate_key,

program(

[assume_native_balance($sender, amount_in_raw, 'exact trade size funded')],

[execute_contract(

$sender,

$router,

amount_in_raw,

500000, -- Simulation ceiling; this is not a transaction gas limit.

$router_abi,

'swapExactETHForTokens',

[$weth, $usdc],

$sender,

9999999999 -- Far-future deadline for simulation only; never broadcast.

)]

) AS program,

[

observation_fact($sender, 'Simulated sender'),

observation_fact($router, 'Router02'),

observation_fact($usdc, 'USDC'),

observe('ETH', native_balance($sender)),

observe('USDC', read_contract($usdc, $erc20_abi, 'balanceOf', $sender))

] AS observations

FROM (

SELECT

candidate_index * $trade_size_step_wei AS amount_in_raw

FROM range(1, 33) AS sizes(candidate_index)

)

CROSS JOIN anchor AS a

)) AS e

)

SELECT

format_ether(r.candidate_key::UINT256) AS amount_in_eth,

format_units(o.delta_magnitude, 6) AS amount_out_usdc,

format_units(

muldiv(

o.delta_magnitude,

parse_ether('1'),

r.candidate_key::UINT256

) AS average_price_usdc_per_eth,

execution_evidence(r.execution_id) AS execution_evidence

FROM executions AS r

LEFT JOIN evm.execution_observation_pairs AS o

ON o.execution_id = r.execution_id

AND o.observation_key = 'USDC'

AND r.status = 'success'

AND o.delta > 0::INT512

ORDER BY r.candidate_key::UINT256;

Compare 12 monthly quotes with one day-one quote.

WETH quoted each month

Monthly quotes overtake the day-one quote in May ’26

Run 32 EVM simulations from one SQL query.

Succeeded

Working on an EVM execution or analysis workflow?

Execute and compare alternatives.

WETH quoted each month

Monthly quotes overtake the day-one quote in May ’26

Run 32 EVM simulations from one SQL query.

Integrity identities 4

Scenario overrides 1

Observed values · 2 requested · 2 resolved

Movements 4

Calls 10

Working on an EVM execution or analysis workflow?