mohammadhop ➡️ eth 2
    Updated 2022-11-01
    with A as (select
    block_timestamp,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    AMOUNT,
    SYMBOL
    from ethereum.core.ez_token_transfers
    where ORIGIN_TO_ADDRESS = lower('0x25ace71c97b33cc4729cf772ae268934f7ab5fa1')
    and SYMBOL IN ('USDC' , 'USDT', 'LUSD', 'TUSD')

    union all

    select
    block_timestamp,
    TX_HASH,
    ORIGIN_FROM_ADDRESS,
    AMOUNT_USD as amount,
    'ETH' as SYMBOL
    from ethereum.core.ez_eth_transfers
    where ORIGIN_TO_ADDRESS = lower('0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'))

    select
    count(distinct TX_HASH) as withdrawn_tx,
    sum(AMOUNT) as withdrawn_amount,
    count(distinct ORIGIN_FROM_ADDRESS) as withdrawn_users,
    SYMBOL
    from A
    group by SYMBOL


    Run a query to Download Data