Query editor
WITH transfers as(selectdate(ts_source) as dt-- date('2025-10-15') 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 chain,case when destination_chain = 'Mantle' then destination_contractelse source_contract end as contract_addressfrom layerzero.messageswhere state = 'Success'and date(ts_source) >= date('2025-07-01')and (source_chain = 'Mantle' or destination_chain = 'Mantle')and project = 'Ethena'and date(ts_source) < current_date),tokens AS(SELECTcontract_address,symbolFROM tokens.erc20where blockchain = 'mantle')selectdt-- ,destination_chain,symbol-- ,min(dt) as dt-- ,chain-- ,project,sum(usd_value) as bridging_volume-- ,SUM(SUM(usd_value)) OVER (ORDER BY dt) AS bridging_volumefrom transfers aleft join tokens b on a.contract_address = cast(b.contract_address as varchar)group by 1,2-- order by 1,3 desc-- select * from-- stargate_mantle.pool_evt_transfer-- where evt_tx_hash = 0x30cad58a8754f2195aab206171e9aca54e4dc3cd3bf4a0372670293ca72c816f