Number of Holders | |
|---|---|
1 | 14233 |
Eman-RazNumber of Unique Holders
Updated 13 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
›
⌄
with tab3 as (
with tab2 as (
with tab1 as (
select tx_from as user, -amount/pow(10,5) as amount
from eclipse.core.fact_transfers
where mint='HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
and succeeded='TRUE'
union all
select tx_to as user, amount/pow(10,5) as amount
from eclipse.core.fact_transfers
where mint='HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'
and succeeded='TRUE')
select user as "Holder", sum(amount) as "Balance"
from tab1
group by 1)
select "Holder", "Balance"
from tab2
where "Balance">0)
select count(distinct "Holder") as "Number of Holders"
from tab3
Last run: about 13 hours agoAuto-refreshes every 24 hours
1
9B
5s