Wallet Age | Number of Holders | |
|---|---|---|
1 | 0 | 77 |
2 | 1 | 2317 |
3 | 2 | 11 |
4 | 3 | 2 |
5 | 4 | 3 |
6 | 5 | 10 |
7 | 6 | 13 |
8 | 7 | 21 |
9 | 8 | 13 |
10 | 9 | 13 |
11 | 10 | 15 |
12 | 11 | 7 |
13 | 12 | 32 |
14 | 13 | 25 |
15 | 14 | 13 |
16 | 15 | 11 |
17 | 16 | 37 |
18 | 17 | 23 |
19 | 18 | 42 |
20 | 19 | 92 |
Eman-RazDemographics of $MOON Token Holders
Updated 2025-02-08
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
36
›
⌄
with table5 as (with table3 as (
with table1 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"
from tab2
where "Balance">0),
table2 as (select signers::array[0] as user, min(block_timestamp::date) as "First Transaction Date"
from eclipse.core.fact_transactions
where succeeded='TRUE'
group by 1)
select "Holder", "First Transaction Date"
from table1 left join table2 on table1."Holder"=table2.user
where "First Transaction Date" is not null),
table4 as (select DISTINCT block_timestamp::date as "Current Date"
from eclipse.core.fact_transactions
where block_timestamp::date = current_date-1)
Last run: about 2 months ago
...
159
1KB
144s