select date_trunc(week,BLOCK_TIMESTAMP)::date weekly ,

count (tx_id) num_transactions ,

count (DISTINCT tx_from) num_active_users,

sum (fee)/1e6 paid_fees ,

sum (num_transactions) over (order by weekly) cum_transactions ,

sum (paid_fees) over (order by weekly) cum_paid_fees,

num_transactions / num_active_users avg_transaction_per_user,

paid_fees / num_transactions avg_paid_fees_per_txn

from axelar.core.fact_transactions

where BLOCK_TIMESTAMP::date >= '2024-01-01'

and BLOCK_TIMESTAMP::date < date_trunc('week',current_date )

group by 1