Txns Value | Number of Users | |
|---|---|---|
1 | <=0.001 $RON | 6650710 |
2 | 0.001-0.01 $RON | 504161 |
3 | 0.01-0.1 $RON | 222146 |
4 | 1-10 $RON | 147550 |
5 | 0.1-1 $RON | 143875 |
6 | 10-100 $RON | 131920 |
7 | 100-1k $RON | 74830 |
8 | 1k-10k $RON | 26813 |
9 | 10k-100k $RON | 6155 |
10 | 100k-1m $RON | 865 |
11 | >1m $RON | 120 |
Eman-RazDistribution of Users Based on Total Transaction Volume
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(value), case
when sum(value)<=0.001 then '<=0.001 $RON'
when sum(value)>0.001 and sum(value)<=0.01 then '0.001-0.01 $RON'
when sum(value)>0.01 and sum(value)<=0.1 then '0.01-0.1 $RON'
when sum(value)>0.1 and sum(value)<=1 then '0.1-1 $RON'
when sum(value)>1 and sum(value)<=10 then '1-10 $RON'
when sum(value)>10 and sum(value)<=100 then '10-100 $RON'
when sum(value)>100 and sum(value)<=1000 then '100-1k $RON'
when sum(value)>1000 and sum(value)<=10000 then '1k-10k $RON'
when sum(value)>10000 and sum(value)<=100000 then '10k-100k $RON'
when sum(value)>100000 and sum(value)<=1000000 then '100k-1m $RON'
when sum(value)>1000000 then '>1m $RON'
end as "Txns Value"
from ronin.core.fact_transactions
where tx_succeeded='TRUE'
group by 1)
select "Txns Value", count(distinct from_address) as "Number of Users"
from tab1
group by 1
order by 2 desc
Last run: about 1 month ago
11
249B
25s