0xHaM-dWINK Holders and Balance on Avalanche
    Updated 2025-02-26
    with eventTb as (
    select
    to_address as holder,
    sum(amount) as amount
    from avalanche.core.ez_token_transfers
    where contract_address = '0x7698a5311da174a95253ce86c21ca7272b9b05f8'
    group by 1
    union all
    select
    from_address as holder,
    sum(amount)*-1 as amount
    from avalanche.core.ez_token_transfers
    where contract_address = '0x7698a5311da174a95253ce86c21ca7272b9b05f8'
    group by 1
    )
    ,
    bal_tb as (
    select
    holder,
    sum(amount) as Balance
    from eventTb
    group by 1
    )
    select
    count(distinct holder) as "# Holders",
    avg(balance) as avg_Balance,
    median(balance) as medain_balance,
    max(balance) as max_balance
    from bal_tb
    where balance > 0



    Last run: about 2 months ago
    # Holders
    AVG_BALANCE
    MEDAIN_BALANCE
    MAX_BALANCE
    1
    4614216731.6859557871847.765308472109281622.0415
    1
    55B
    3s