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 osmosis.core.fact_transfers x

join osmosis.core.dim_labels on currency = address

where project_name in ('USDC.axl','USDC.grv')

and block_timestamp::date >= current_date - 30

group by 1