N_HOLDERS_7D | |
---|---|
1 | 32197 |
gigiokoba7 days
Updated 2024-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with address_balance_7d as (
select
OWNER,
BALANCE,
row_number() over(partition by owner order by block_timestamp desc) as rank
from solana.core.fact_token_balances
where SUCCEEDED
and mint = 'Df6yfrKC8kZE3KNkrHERKzAetSxbrWeniQfyJY4Jpump'
and block_timestamp >= CURRENT_DATE - 7
)
select
count(DISTINCT owner) as N_Holders_7D
from address_balance_7d
where balance > 0
and rank = 1;
Last run: about 2 months ago
1
9B
14s