when source_chain='solana' then 'Solana'

when source_chain='aptos' then 'Aptos'

when source_chain='blast' then 'Blast'

end as "Source Chain",

sum(amount_usd) as "Volume of Transfers",

count(distinct tx_hash) as "Number of Transfers",

count(distinct source_address) as "Number of Users",

count(distinct (source_chain || '➡' || destination_chain)) as "Number of Routes",

case

when platform in ('layerzero','layerzero-v2','stargate') then 'LayerZero'

when platform = 'wormhole' then 'Wormhole'

end as "Cross-Chain Service"

from crosschain.defi.ez_bridge_activity

where platform in ('layerzero','layerzero-v2','stargate','wormhole') and block_timestamp::date>='2024-01-01'

and source_chain in ('blast','solana')

group by 1, 6

union all

select case

when source_chain in ('Aptos','aptos') then 'Aptos'

end as "Source Chain",

round(sum(amount_in_usd),2) as "Volume of Transfers",

count(distinct tx_hash) as "Number of Transfers",

count(distinct sender) as "Number of Users",

count(distinct (source_chain || '➡' || destination_chain)) as "Number of Routes",

case

when platform = 'layerzero' then 'LayerZero'

when platform = 'wormhole' then 'Wormhole'

end as "Cross-Chain Service"

from aptos.defi.ez_bridge_activity

where source_chain in ('Aptos','aptos') and platform in ('layerzero','wormhole')

and block_timestamp::date>='2024-01-01'

group by 1, 6