flipside

    Top $PAC Holders
    mamad-5XN3k3Top $PAC Holders
    Updated 2024-06-08
    with enst as (
    select
    OWNER,
    ENS_DOMAIN
    from ethereum.ens.ez_ens_domains
    where ENS_SET = 'TRUE'
    )

    select
    distinct user,
    --ADDRESS_name,
    sum(vol) as balance
    from (
    select
    to_address as user,
    sum(amount) as vol
    from blast.core.ez_token_transfers
    where contract_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
    and amount is not null
    group by 1

    UNION

    select
    from_address as user,
    -1 * sum(amount) as vol
    from blast.core.ez_token_transfers
    where contract_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
    and amount is not null
    group by 1
    )
    --left join ethereum.core.dim_labels on address = user
    --left join enst on user = OWNER
    group by 1
    order by 2 desc
    QueryRunArchived: QueryRun has been archived