mohammadheth ➡️ op 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 TO_ADDRESS = lower('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1')
    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 ETH_TO_ADDRESS = lower('0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'))

    select
    count(distinct TX_HASH) as deposit_tx,
    sum(AMOUNT) as deposit_amount,
    count(distinct ORIGIN_FROM_ADDRESS) as deposit_users,
    SYMBOL
    from A
    group by SYMBOL


    Run a query to Download Data