Balance Size | Number of Users | |
|---|---|---|
1 | V<=0.001 tETH | 79905 |
2 | 0.001<V<=0.01 tETH | 30640 |
3 | 0.01<V<=0.1 tETH | 17755 |
4 | 0.1<V<=1 tETH | 1723 |
5 | V>1 tETH | 112 |
Eman-RazDistribution of Users By tETH Balance
Updated 22 hours ago
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
›
⌄
with tab3 as (with tab2 as (with tab1 as (select tx_from as user, -amount/pow(10,9) as volume
from eclipse.core.fact_transfers
where mint='GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'
and succeeded='TRUE'
union all
select tx_to as user, amount/pow(10,9) as volume
from eclipse.core.fact_transfers
where mint='GU7NS9xCwgNPiAdJ69iusFrRfawjDDPjeMBovhV1d4kn'
and succeeded='TRUE')
select user, sum(volume) as balance
from tab1
group by 1)
select user, balance, case
when balance<=0.001 then 'V<=0.001 tETH'
when balance>0.001 and balance<=0.01 then '0.001<V<=0.01 tETH'
when balance>0.01 and balance<=0.1 then '0.01<V<=0.1 tETH'
when balance>0.1 and balance<=1 then '0.1<V<=1 tETH'
when balance>1 then 'V>1 tETH'
end as "Balance Size"
from tab2
where balance>0)
select "Balance Size", count(distinct user) as "Number of Users"
from tab3
group by 1
order by 2 desc
Last run: about 22 hours agoAuto-refreshes every 24 hours
5
121B
131s