Query editor
-- Configured recipients only: these counts are not paid fees or revenue.-- One filtered pass per chain; no self joins, transfer joins, prices or CTE reuse.-- Successful trace/transaction flags do not independently establish all ancestor outcomes.-- Fixed snapshot matches the existing revenue ledger, ending 2026-11-18 at 12:00 UTC.WITH helper_calls AS (SELECT 'ethereum' AS blockchain, block_time, tx_hash,varbinary_substring(input, 241, 20) AS fee_receiver,varbinary_substring(input, 209, 20) AS output_receiver,varbinary_substring(input, 165, 32) AS output_cap_wordFROM ethereum.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time >= TIMESTAMP '2026-01-01 00:00:00'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND "to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eAND varbinary_substring(input, 1, 4) = 0x346387bfAND length(input) >= 324AND varbinary_substring(input, 229, 12) = 0x000000000000000000000000UNION ALLSELECT 'optimism' AS blockchain, block_time, tx_hash,varbinary_substring(input, 241, 20) AS fee_receiver,varbinary_substring(input, 209, 20) AS output_receiver,varbinary_substring(input, 165, 32) AS output_cap_wordFROM optimism.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time >= TIMESTAMP '2026-01-01 00:00:00'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND "to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eAND varbinary_substring(input, 1, 4) = 0x346387bfAND length(input) >= 324AND varbinary_substring(input, 229, 12) = 0x000000000000000000000000UNION ALLSELECT 'bnb' AS blockchain, block_time, tx_hash,varbinary_substring(input, 241, 20) AS fee_receiver,varbinary_substring(input, 209, 20) AS output_receiver,varbinary_substring(input, 165, 32) AS output_cap_wordFROM bnb.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time >= TIMESTAMP '2026-01-01 00:00:00'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND "to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eAND varbinary_substring(input, 1, 4) = 0x346387bfAND length(input) >= 324AND varbinary_substring(input, 229, 12) = 0x000000000000000000000000UNION ALLSELECT 'unichain' AS blockchain, block_time, tx_hash,varbinary_substring(input, 241, 20) AS fee_receiver,varbinary_substring(input, 209, 20) AS output_receiver,varbinary_substring(input, 165, 32) AS output_cap_wordFROM unichain.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time >= TIMESTAMP '2026-01-01 00:00:00'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND "to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eAND varbinary_substring(input, 1, 4) = 0x346387bfAND length(input) >= 324AND varbinary_substring(input, 229, 12) = 0x000000000000000000000000