elsinaTotal USDC transferring
    Updated 2022-12-09
    -- 2022-04-18
    -- eth 0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48
    -- bsc 0x8ac76a51cc950d9822d68b83fe1ad97b32cd580d
    -- sol EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v
    -- axl
    -- arb 0xff970a61a04b1ca14834a43f5de4533ebddb5cc8
    -- op 0x7f5c764cbc14f9669b88837ca1490cca17c31607
    -- ava 0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e
    -- ner a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near
    -- pol 0x2791bca1f2de4661ed88a30c99a7a9449aa84174
    -- alg 31566704
    -- osm ibc/D189335C6E4A68B513C10AB227BF1C1D38C746766278BA3EEB4FB14124F1D858

    select
    'Ethereum' as chain,
    count(distinct tx_hash) as count,
    count(distinct from_address) as senders,
    count(distinct to_address) as receivers,
    sum(amount) as volume,
    avg(amount) as average_size
    from ethereum.core.ez_token_transfers
    where
    block_timestamp::date >= '{{start_date}}' and block_timestamp::date <= '{{end_date}}' and
    contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48'
    group by 1

    union all
    select
    'Optimism' as chain,
    count(distinct tx_hash) as count,
    count(distinct from_address) as senders,
    count(distinct to_address) as receivers,
    sum(raw_amount/1e6) as volume,
    avg(raw_amount/1e6) as average_size
    from optimism.core.fact_token_transfers
    Run a query to Download Data