Flipside Axelar AnalystsSolana + Blast + Aptos
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
›
⌄
select case
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
QueryRunArchived: QueryRun has been archived