Ali3NAverage Stablejack Users Activity
    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 t1.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 round(avg(transactions)) as Average_Transactions,
    round(avg(active_days)) as Average_Active_Days
    from userst




    QueryRunArchived: QueryRun has been archived