Ali3NBenqi Stakers Distribution By Loyalty Status (Avalanche's Benqi vs Aptos's Amnis)
    Updated 2025-02-22
    with Staket as (
    select distinct origin_from_address
    from avalanche.core.ez_decoded_event_logs
    where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    and event_name ilike 'Submitted'
    group by 1),

    Unstaket as (
    select distinct origin_from_address
    from avalanche.core.ez_decoded_event_logs
    where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    and event_name ilike 'Redeem'
    group by 1

    union all

    select distinct origin_from_address
    from avalanche.core.ez_decoded_event_logs
    where contract_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
    and event_name ilike 'UnlockRequested'
    group by 1),

    Staket1 as (
    select distinct sender
    from aptos.core.fact_events t1 join aptos.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
    where t1.event_resource in ('MintEvent')
    and t1.event_module = 'stapt_token'
    and t1.payload_function like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
    group by 1),

    Unstaket1 as (
    select distinct sender
    from aptos.core.fact_events t1 join aptos.core.fact_transactions t2 on t1.tx_hash = t2.tx_hash
    where t1.event_resource in ('BurnEvent')
    and t1.event_module = 'stapt_token'
    and t1.payload_function like '0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a%'
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived