Query editor
-- =====================================================================-- QUERY: cirBTC Ethereum — Platform-to-Platform Flows-- PURPOSE: Every distinct (from_label -> to_label) pair within the-- window, with amount/tx/unique-wallet rollups. Each row IS-- one hop; hops are never merged across intermediaries, so a-- multi-hop path (Wallet A -> DEX -> Lending -> Wallet B)-- shows as 3 separate, fully accurate rows rather than being-- collapsed into Wallet A -> Wallet B.-- DEPENDS ON: query 7775922 (Base Labeled Transfers)-- =====================================================================selectfrom_label as from_protocol,to_label as to_protocol,sum(amount) as amount_cirbtc,count(distinct evt_tx_hash) as transactions,count(distinct "from") + count(distinct "to") as unique_wallets_involvedfrom query_7775922where evt_block_time >= now() - (case '{{time_window}}'when '24h' then interval '1' daywhen '7d' then interval '7' daywhen '30d' then interval '30' dayend)group by 1, 2order by amount_cirbtc desc