Query editor
-- PREPARED ONLY. Fresh approval required: complete receiver-discovery v10 batch.-- One Medium execution; up to two exports of 10000 rows; no execution retries.-- Discover all configured surplus receivers at the documented v5 helper on 19 chains.-- This is broader than the five previously selected collector addresses.-- Successful transfer-call amounts are nominal token units, NOT USD revenue.-- No fee receiver is assumed to belong to Enso. Legacy helpers/other revenue channels remain separate.WITH raw_calls AS (SELECT 'ethereum' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM ethereum.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)UNION ALLSELECT 'optimism' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM optimism.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)UNION ALLSELECT 'bnb' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM bnb.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)UNION ALLSELECT 'unichain' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM unichain.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)UNION ALLSELECT 'polygon' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM polygon.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)UNION ALLSELECT 'monad' AS blockchain, block_date, block_time, tx_hash, trace_address,"from" AS sender, "to" AS target, input, output, valueFROM monad.tracesWHERE block_date >= DATE '2026-01-01' AND block_date <= DATE '2026-11-18'AND block_time < TIMESTAMP '2026-11-18 12:00:00'AND success AND tx_success AND type = 'call' AND call_type = 'call'AND ("to" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477eOR "from" = 0xbedfac7488dccaafdd66d1d7d56349780fe0477e)