Updated 2022-11-01
    select
    BLOCK_TIMESTAMP::date as date,
    count(ORIGIN_TO_ADDRESS)as number_USDC,
    sum (AMOUNT / pow (10,b.decimals)) as a_amount_USDC
    -- 'USDT' as Tag
    from ethereum.core.ez_token_transfers a
    join ethereum.core.dim_contracts b on b.address = a.ORIGIN_FROM_ADDRESS
    where a.symbol = 'USDC'
    group by 1
    order by 1
    Run a query to Download Data