Moeaxl txns %
    Updated 2025-02-04
    select
    date ,
    round ( 100*(transactions-lag(transactions,1)over(order by date))/lag(transactions,1)over(order by date),2) as "transactions change %",
    round ( 100*(active_addresses-lag(active_addresses,1)over(order by date))/lag(active_addresses,1)over(order by date),2) as "active_addresses change %",
    round ( 100*(txn_per_user-lag(txn_per_user,1)over(order by date))/lag(txn_per_user,1)over(order by date),2) as "txn_per_user change %",
    round ( 100*(txn_per_day-lag(txn_per_day,1)over(order by date))/lag(txn_per_day,1)over(order by date),2) as "txn_per_day change %",
    round ( 100*(users_per_day-lag(users_per_day,1)over(order by date))/lag(users_per_day,1)over(order by date),2) as "users_per_day change %"
    from

    (select
    date_trunc('week', BLOCK_TIMESTAMP)::date AS date,
    count(TX_id) AS transactions,
    count(distinct TX_FROM) AS active_addresses ,
    transactions / active_addresses as txn_per_user ,
    transactions / count(distinct BLOCK_TIMESTAMP::date ) as txn_per_day,
    active_addresses / count(distinct BLOCK_TIMESTAMP::date ) as users_per_day,


    from axelar.core.fact_transactions
    where TX_SUCCEEDED='TRUE'
    and BLOCK_TIMESTAMP between CURRENT_DATE - interval '2 months' and current_date
    group by 1
    )

    order by date desc limit 1



    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived