Ali3NUsers Distribution By Transactions (Stablejack)
    Updated 2025-02-04
    with stablejackt as (
    select '0x013b34dba0d6c9810f530534507144a8646e3273' as address,

    union all

    select '0x0363a3debe776de575c36f524b7877db7dd461db' as address

    union all

    select '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e' as address,

    union all

    select '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' as address
    ),

    userst as(
    select origin_From_address,
    count (distinct tx_hash) as Transactions,
    count (distinct block_timestamp::date) as Active_Days
    from avalanche.core.ez_decoded_event_logs t1 join stablejackt t2 on t1.origin_to_address = t2.address
    group by 1)

    select case when transactions = '1' then '1 TX'
    when transactions >= '2' and transactions <= '5' then '2 - 5 TXs'
    when transactions >= '6' and transactions <= '10' then '6 - 10 TXs'
    else '> 10 TXs' end as type1,
    count (distinct origin_from_address) as Users
    from userst
    group by 1



    QueryRunArchived: QueryRun has been archived