Query editor
SELECTa.source_chain,a.destination_chain,COUNT(*) AS transfer_count,SUM(COALESCE(b.usd_value, 0)) AS total_volume_usdFROM layerzero.messages aLEFT JOIN layerzero.transfers bON a.primary_key = b.messages_foreign_keyWHEREb.type_transfer = 'oft'AND b.symbol = 'WXTZ' -- OFT tokenGROUP BYa.source_chain,a.destination_chainORDER BYtransfer_count DESC;