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,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'))select dt,direction-- ,chain,sum(usd_value) as bridging_volume,SUM(SUM(usd_value)) OVER (partition by direction ORDER BY dt ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) as vol_7dfrom transfersgroup by 1,2-- select * from-- stargate_mantle.pool_evt_transfer-- where evt_tx_hash = 0x30cad58a8754f2195aab206171e9aca54e4dc3cd3bf4a0372670293ca72c816f