Eman-RazAverage/Median Number of User Transactions
    Updated 2025-02-04
    with tab1 as (select from_address as user, count(distinct tx_hash) as txns_count
    from aurora.core.fact_transactions
    where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'
    and status='SUCCESS'
    group by 1)

    select round(avg(txns_count)) as avg_txn_count, median(txns_count) as median
    from tab1
    Last run: 3 months ago
    AVG_TXN_COUNT
    MEDIAN
    1
    171
    1
    8B
    3s