Afonso_DiazSwap Categories
    Updated 2025-05-19
    with transfers as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address,
    'RON' as symbol,
    amount,
    amount_usd,
    from_address,
    to_address
    from ronin.core.ez_native_transfers
    where origin_from_address in (from_address, to_address)
    and origin_to_address = '0x6131b5fae19ea4f9d964eac0408e4408b66337b5'
    union all

    select
    tx_hash,
    block_timestamp,
    origin_from_address,
    symbol,
    amount,
    amount_usd,
    from_address,
    to_address
    from ronin.core.ez_token_transfers
    where origin_from_address in (from_address, to_address)
    and origin_to_address = '0x6131b5fae19ea4f9d964eac0408e4408b66337b5'
    ),

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as swapper,
    a.symbol as symbol_out,
    Last run: 12 days ago
    CATEGORY
    TRANSACTION_COUNT
    1
    Shrimp ($10 - $100)1453
    2
    Plankton (< $10)1389
    3
    Crab ($100 - $1K)593
    4
    Octopus ($1K - $10K)38
    5
    Fish ($10K - $100K)1
    5
    136B
    1s