Query editor
withinflows as (selectdate_trunc('day', ts_source) as date,source_chain,sum(usd_value) as volume_usdfromlayerzero.messageswherestate = 'Success'and destination_chain = 'Plasma'and destination_chain != source_chaingroup by1, 2),outflows as (selectdate_trunc('day', ts_source) as date,destination_chain,sum(usd_value) as volume_usdfromlayerzero.messageswherestate = 'Success'and source_chain = 'Plasma'and destination_chain != source_chaingroup by1, 2),blockchains as (select distinctsource_chain as blockchainfrominflowsunionselect distinctdestination_chainfromoutflows),dates as (selecttimestamp as date,blockchainfromutils.dayscross join blockchainswheredate(timestamp) >= date('2025-09-25')),summary as (selectd.date,d.blockchain,coalesce(i.volume_usd, 0) as inflow_usd,coalesce(o.volume_usd, 0) as outflow_usd,coalesce(i.volume_usd, 0) - coalesce(o.volume_usd, 0) as netflow_usdfromdates as dleft join inflows as i on d.date = i.date