N_HOLDERS_30D | |
---|---|
1 | 143211 |
gigiokoba30 Days
Updated 2024-12-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
with address_balance_30d 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 - 30
)
select
count(DISTINCT owner) as N_Holders_30D
from address_balance_30d
where balance > 0
and rank = 1;
Last run: about 2 months ago
1
10B
42s