Query editor
-- Fixed-scope diagnostic for the three Base solver aggregates whose retained-- public q4070065 transaction sum does not reproduce the uploaded payout input-- after a single IEEE-754 binary64 projection.---- This query intentionally exposes only public Dune lineage. It cannot attest-- to the private production/staging relation, PostgreSQL type, deployed fold-- order, transformation invocation, or payout invocation that produced-- fct_data_per_solver_and_accounting_period.sum_slippage_native.with target_solvers (solver) as (values(0x0195214d609edc3032366eb5c977d26d46d0a661),(0x6bf97afe77ca5f92d209233be83d5919144207d2),(0xa95157266e0f53d2762fd8a885d4cdb2409eb29e)),official as (selectcast(env as varchar) as environment,solver,cast(sum_slippage_native as varchar) as sum_slippage_nativefrom dune.cowprotocol.dataset_prod_data_per_solver_and_accounting_period_basewhereenv = 'prod'and cast(accounting_period_start_time as timestamp) = timestamp '2026-07-14 00:00:00'and cast(accounting_period_end_time as timestamp) = timestamp '2026-07-21 00:00:00'and solver in (select solver from target_solvers)union allselectcast(env as varchar) as environment,solver,cast(sum_slippage_native as varchar) as sum_slippage_nativefrom dune.cowprotocol.dataset_staging_data_per_solver_and_accounting_period_basewhereenv = 'staging'and cast(accounting_period_start_time as timestamp) = timestamp '2026-07-14 00:00:00'and cast(accounting_period_end_time as timestamp) = timestamp '2026-07-21 00:00:00'and solver in (select solver from target_solvers)),excluded_batches as (select tx_hashfrom query_3490353),native_prices as (selectdate_trunc('hour', minute) as hour,avg(price) as price_unit,avg(price) / pow(10, 18) as price_atomfrom prices.usdwhereblockchain = 'base'and contract_address = 0x4200000000000000000000000000000000000006and minute >= timestamp '2026-07-14 00:00:00'and minute < timestamp '2026-07-21 00:00:00'group by 1),