Afonso_DiazTop Deposit Pools
    Updated 2025-04-09
    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
    Last run: 15 days ago
    TOKEN_PAIR
    TRANSACTIONS
    USERS
    VOLUME_USD
    AVERAGE_AMOUNT_USD
    1
    WETH - RON14637366237193559.18219032541.064369898
    2
    USDC - RON16044423029942249.9653531866.258412201
    3
    RON - AXS808320498141098.252197131007.187709043
    4
    YGG - RON17174946526948.088654063801.367553089
    5
    SLP - RON618219156305591.713180881019.992189127
    6
    USDC - AXS152822431848.3415999.002236842
    7
    RON - CAG5121621613780.105625063151.914268799
    8
    RON - KOKU313851162714.188401963714.741815981
    9
    RON - KDR1353493915115.029865999676.359962946
    10
    USDC - KOKU137726474.655882.661538462
    10
    540B
    3s