Metiocreaverage USDC transfer size [Eth, Solana, Algo]
    Updated 2022-04-24
    with solana as (
    SELECT avg(amount) as average
    from solana.fact_transfers
    where date(block_timestamp) >= '2022-01-01'
    and mint = 'EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v'
    ),
    algo as (
    SELECT avg(asset_amount)/10e6 as average
    from algorand.asset_transfer_transaction
    where date(block_timestamp) >= '2022-01-01'
    and asset_id = '31566704'
    ),
    eth as (
    select avg(udm.amount) as average
    from ethereum.transactions as transactions , ethereum.udm_events as udm
    where DATE(transactions.BLOCK_TIMESTAMP) >= '2022-01-01'
    and transactions.FUNCTION_NAME = 'transfer'
    and transactions.symbol = 'USDC'
    and transactions.tx_id = udm.tx_id
    )

    SELECT eth.average as Eth , algo.average as Algo, solana.average as Solana
    from solana , algo , eth
    Run a query to Download Data