select
sum(amount/pow(10,decimal)) as total_amount,
count(distinct tx_id) as transactions,
count(distinct sender) as wallets,
total_amount/transactions as average_amount_per_transfer,
total_amount/wallets as average_amount_per_wallet
from axelar.core.fact_transfers
where currency = 'uusdc' and TX_SUCCEEDED = 'TRUE'
and block_timestamp::date >= current_date - 30