Query editor
WITH transfers as(selectdate(ts_source) as dt-- date_trunc('month',ts_source) as dt,source_chain,source_contract,destination_chain,destination_contract,addr_from as user,project-- ,usd_value,case when destination_chain = 'Mantle' then usd_valueelse -usd_value end as usd_value,case when destination_chain = 'Mantle' then 'Inflow'else 'Outflow' end as direction,case when destination_chain = 'Mantle' then source_chainelse destination_chain end as chainfrom layerzero.messageswhere state = 'Success'and date(ts_source) >= date('2025-07-01')and (source_chain = 'Mantle' or destination_chain = 'Mantle'))selectdt-- ,destination_chain,chain-- ,project,sum(usd_value) as bridging_volume-- ,SUM(SUM(usd_value)) OVER (ORDER BY dt) AS bridging_volumefrom transfersgroup by 1,2order by 1 desc, 3 desc-- select * from-- stargate_mantle.pool_evt_transfer-- where evt_tx_hash = 0x30cad58a8754f2195aab206171e9aca54e4dc3cd3bf4a0372670293ca72c816f