kasadeghUntitled Query
    Updated 2022-11-21

    SELECT
    'ethereum' as chain,
    count(distinct TX_HASH) as tx_count,
    sum(amount) as total_volume,
    avg(amount) as avg_volume,
    median(amount) as median_volume,
    count(DISTINCT FROM_ADDRESS) as senders_cnt,
    count(DISTINCT TO_ADDRESS) as receivers_cnt
    FROM ethereum.core.ez_token_transfers
    where symbol='USDC'
    AND block_timestamp::date >='{{start_time}}' and block_timestamp::date <='{{end_date}}'
    GROUP BY 1

    Run a query to Download Data