Class | Transfers Count | |
|---|---|---|
1 | 10k<V<=20k ATH | 492 |
2 | V>100k ATH | 1103 |
3 | 20k<V<=50k ATH | 599 |
4 | 1k<V<=10k ATH | 2686 |
5 | 100<V<=1k ATH | 446 |
6 | 50k<V<=100k ATH | 598 |
7 | V<=100 ATH | 159 |
Eman-RazDistribution of Interchain Transfers Based on Volume
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
with tab1 as (select id, case
when sum(amount)<=100 then 'V<=100 ATH'
when sum(amount)>100 and sum(amount)<=1000 then '100<V<=1k ATH'
when sum(amount)>1000 and sum(amount)<=10000 then '1k<V<=10k ATH'
when sum(amount)>10000 and sum(amount)<=20000 then '10k<V<=20k ATH'
when sum(amount)>20000 and sum(amount)<=50000 then '20k<V<=50k ATH'
when sum(amount)>50000 and sum(amount)<=100000 then '50k<V<=100k ATH'
when sum(amount)>100000 then 'V>100k ATH'
end as "Class"
from axelar.axelscan.fact_gmp
where call ilike '%0xb5fb4be02232b1bba4dc8f81dc24c26980de9e3c%'
and (data:executed:receipt:logs[1]:address=lower('0xbe0Ed4138121EcFC5c0E56B40517da27E6c5226B')
or data:executed:receipt:logs[1]:address=lower('0xc87B37a581ec3257B734886d9d3a581F5A9d056c'))
and (created_at::date between '{{Start_Date}}' and '{{End_Date}}')
and amount is not null
group by 1)
select "Class", count(distinct id) as "Transfers Count"
from tab1
group by 1
Last run: 29 days agoAuto-refreshes every 24 hours
7
155B
122s