Txn Fees | Number of Users | |
|---|---|---|
1 | 0.001-0.01 $RON | 3621994 |
2 | 0.01-0.1 $RON | 2509725 |
3 | <=0.001 $RON | 1246926 |
4 | 0.1-1 $RON | 509097 |
5 | 1-10 $RON | 20110 |
6 | 10-100 $RON | 1081 |
7 | 100-1k $RON | 184 |
8 | 1k-10k $RON | 28 |
Eman-RazDistribution of Users Based on Total Transaction Fees
Updated 2025-03-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with tab1 as (select from_address, sum(tx_fee), case
when sum(tx_fee)<=0.001 then '<=0.001 $RON'
when sum(tx_fee)>0.001 and sum(tx_fee)<=0.01 then '0.001-0.01 $RON'
when sum(tx_fee)>0.01 and sum(tx_fee)<=0.1 then '0.01-0.1 $RON'
when sum(tx_fee)>0.1 and sum(tx_fee)<=1 then '0.1-1 $RON'
when sum(tx_fee)>1 and sum(tx_fee)<=10 then '1-10 $RON'
when sum(tx_fee)>10 and sum(tx_fee)<=100 then '10-100 $RON'
when sum(tx_fee)>100 and sum(tx_fee)<=1000 then '100-1k $RON'
when sum(tx_fee)>1000 and sum(tx_fee)<=10000 then '1k-10k $RON'
when sum(tx_fee)>10000 and sum(tx_fee)<=100000 then '10k-100k $RON'
when sum(tx_fee)>100000 and sum(tx_fee)<=1000000 then '100k-1m $RON'
when sum(tx_fee)>1000000 then '>1m $RON'
end as "Txn Fees"
from ronin.core.fact_transactions
where tx_succeeded='TRUE'
group by 1)
select "Txn Fees", count(distinct from_address) as "Number of Users"
from tab1
group by 1
order by 2 desc
Last run: about 1 month ago
8
182B
5s