adriaparcerisasterra old bounty ax1
    Updated 2022-11-22
    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

    Run a query to Download Data