tETH Holders | % of Users | |
|---|---|---|
1 | 127861 | 0.118 |
Eman-RaztETH Holders
Updated 2 days 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
›
⌄
with teth_holders 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 count(distinct user) as "tETH Holders"
from tab2
where balance>0),
eclipse_users as (select count(distinct signers[0]) as "Eclipse Users"
from eclipse.core.fact_transactions
where succeeded='TRUE')
select "tETH Holders", round(("tETH Holders"/"Eclipse Users"),3) as "% of Users"
from teth_holders, eclipse_users
Last run: 2 days ago
1
16B
622s