strawbetty average USDC transfer size
    Updated 2022-04-19
    select (sum(swap_from_amount)/count(*)) as avg , 'algorand'
    from algorand.swaps
    where
    block_timestamp::date >= '2022-01-01' and ( swap_from_asset_id=31566704 )
    union

    select (sum(swap_from_amount)/count(*)) as avg,'solana'
    from solana.swaps
    where
    block_timestamp::date >= '2022-01-01'
    and swap_from_mint ='EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'

    union
    select (sum(amount_usd)/count(*)) as avg , 'ethereum'
    from ethereum.dex_swaps
    where block_timestamp::date >= '2022-01-01' and (POOL_NAME like 'USDC-%')
    Run a query to Download Data