gigiokoba7 days
    Updated 2024-12-12
    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
    N_HOLDERS_7D
    1
    32197
    1
    9B
    14s