select count (TX_FROM) num_new_users ,

sum (tx_by_new) num_txns_by_new_users

from (

select TX_FROM,

min (BLOCK_TIMESTAMP)::date min_date ,

count (tx_id) tx_by_new

from axelar.core.fact_transactions

group by 1 having min_date >= '2024-01-01'

),

active_users as (

select

count (tx_id) num_transactions ,

count (DISTINCT tx_from) num_active_users,

sum (fee)/1e6 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 )

select num_new_users ,

num_active_users ,

num_transactions ,

paid_fees,

avg_transaction_per_user,

avg_paid_fees_per_txn,

from new_users , active_users