date_trunc(week,block_timestamp) as Week,

date_trunc(month,block_timestamp) as Date ,

monthname(BLOCK_TIMESTAMP) AS Month,

count(TX_id) AS Txns,

count(distinct TX_FROM) AS Active_Users,

sum(FEE/1e6) AS Total_fee,

Total_fee/Txns as Fee_per_txn,

Total_fee/count(distinct BLOCK_TIMESTAMP::date ) as Fee_per_day,

Txns/Active_Users as Txns_per_user,

Txns/count(distinct BLOCK_TIMESTAMP::date ) as Txns_per_day,

Active_Users/count(distinct BLOCK_TIMESTAMP::date ) as wallets_per_day

from axelar.core.fact_transactions where TX_SUCCEEDED='TRUE' and BLOCK_TIMESTAMP::date between '2022-12-01' and CURRENT_DATE-1

group by 1,2,3

ORDER by 1 DESC