Afonso_Diazfresh-lavender
    Updated 2025-03-07
    with

    deposits as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    'RON' as symbol,
    amount,
    amount_usd,
    'V2' as version
    from
    ronin.core.ez_native_transfers
    where
    origin_from_address = from_address
    and origin_to_address = '0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7'

    union all

    select
    tx_hash,
    block_timestamp,
    origin_from_address as user,
    symbol,
    amount,
    amount_usd,
    'V2' as version
    from
    ronin.core.ez_token_transfers
    where
    origin_from_address = from_address
    and origin_to_address = '0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7'

    union all

    select
    QueryRunArchived: QueryRun has been archived