alitaslimiAvalanche Holders Types
    Updated 2025-02-19
    with
    transfers as (
    select
    to_address as address,
    sum(amount) as volume
    from
    avalanche.core.ez_token_transfers
    where
    contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    group by
    address
    union all
    select
    from_address as address,
    -sum(amount) as volume
    from
    avalanche.core.ez_token_transfers
    where
    contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'
    group by
    address
    ),
    holders as (
    select
    address,
    sum(volume) as balance
    from
    transfers
    where
    address != '0x0000000000000000000000000000000000000000'
    group by
    address
    having
    balance > 0
    )
    select
    Last run: 24 days ago
    Label
    Holders
    Balance
    1
    DeFi454086.7593713
    2
    Other230448842.88844294
    3
    DEX15292.95757205
    4
    CEX1260.18120417
    5
    DApp56.405986852e-14
    5
    130B
    9s