Query editor
selectm.tx_hash_source as tx_hash, block_date, m.project, m.source_chain_key as blockchain, SUM(t.usd_value) as volume_usdfrom layerzero.transfers tinner join layerzero.messages m on t.messages_foreign_key = m.primary_keyinner join dune.canaryprotocol.result_transaction_list_include_fee_paide_to_wbtc_canary_dvn c on m.tx_hash_source = CAST(c.tx_hash as varchar)and ((c.chain = 'bnb'and m.source_chain_key = 'bsc')or (c.chain = 'berachain'and m.source_chain_key = 'bera')or (c.chain = 'avalanche_c'and m.source_chain_key = 'avalanche')or c.chain = m.source_chain_key)where block_date < DATE '2026-07-09'and m.project = 'wBTC'and m.state = 'Success'and (t.symbol = 'WBTC')group bym.tx_hash_source, c.block_date, m.project, m.source_chain_keyorder byvolume_usd desc;