flipside

    Holders vs. Sellers ($NRN)
    Monitize AIHolders vs. Sellers ($NRN)
    Updated 2024-07-15
    with claimert as (
    select
    distinct TO_ADDRESS as claimer,
    sum(amount) as Claimed_Amount
    from arbitrum.core.ez_token_transfers
    where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')
    and FROM_ADDRESS = lower('0xb063f2af926af95f08515fd9d5f2397ce97148bf')
    and ORIGIN_FUNCTION_SIGNATURE = '0x2f0879f7'
    group by 1
    ),

    balancet as (
    select
    distinct user_address,
    sum(volume) as Holding_Volume
    from(
    select
    from_address as user_address,
    -1 * amount as volume
    FROM arbitrum.core.ez_token_transfers
    where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')

    union all

    select
    to_address as user_address,
    amount as volume
    FROM arbitrum.core.ez_token_transfers
    where CONTRACT_ADDRESS = lower('0xdadeca1167fe47499e53Eb50F261103630974905')
    )
    join claimert on USER_ADDRESS = claimer
    group by user_address
    having sum(volume) > 0
    ),

    /*
    QueryRunArchived: QueryRun has been archived