gigiokoba30 Days
    Updated 2024-12-12
    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
    N_HOLDERS_30D
    1
    143211
    1
    10B
    42s