Ali3NTransactions and Users Over Time (Stablejack)
    Updated 2025-02-04
    with t2 as (
    select '0x013b34dba0d6c9810f530534507144a8646e3273' as address,

    union all

    select '0x0363a3debe776de575c36f524b7877db7dd461db' as address

    union all

    select '0x698c34bad17193af7e1b4eb07d1309ff6c5e715e' as address,

    union all

    select '0xabe7a9dfda35230ff60d1590a929ae0644c47dc1' as address
    )

    select date_trunc (week,block_timestamp) as date,
    count (distinct tx_hash) as Transactions,
    count (distinct origin_from_address) as Active_Users,
    sum (transactions) over (order by date) as Total_Transactions
    from avalanche.core.ez_decoded_event_logs t1 join t2 on t1.origin_to_address = t2.address
    group by 1
    order by 1 desc


    QueryRunArchived: QueryRun has been archived