select date_trunc('day', block_timestamp) as date,

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

group by 1

)

select avg(total_amount) as avg_total_amount_day,

avg(transactions) as avg_transactions_day,

avg(wallets) as avg_wallets_day,

avg(average_amount_per_transfer) as avg_average_amount_per_transfer_day,

avg(average_amount_per_wallet) as avg_average_amount_per_wallet_day

from main