Afonso_Diaztxns breakdown
    Updated 2025-03-25
    with

    main as (
    select
    tx_hash,
    block_timestamp,
    origin_from_address as swapper,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out,
    pool_name,
    'BSC' as chain
    from
    bsc.defi.ez_dex_swaps
    where
    tx_hash in (select distinct tx_hash from bsc.core.ez_native_transfers where to_address = '0x90cbe4bdd538d6e9b379bff5fe72c3d67a521de5')

    union all

    select
    tx_hash,
    block_timestamp,
    origin_from_address as swapper,
    nvl(amount_in_usd, amount_out_usd) as amount_usd,
    symbol_in,
    symbol_out,
    pool_name,
    'Base' as chain
    from
    base.defi.ez_dex_swaps
    where
    tx_hash in (select distinct tx_hash from base.core.ez_native_transfers where to_address = '0x90cbe4bdd538d6e9b379bff5fe72c3d67a521de5')

    union all

    select
    Last run: 23 days ago
    CHAIN
    AMOUNT_CATEGORY
    TX_COUNT
    1
    BaseShark ($1,000 - $9,999)64
    2
    PolygonShark ($1,000 - $9,999)3
    3
    BSCDolphin ($100 - $999)1199
    4
    EthereumFish ($10 - $99)268
    5
    ArbitrumDolphin ($100 - $999)485
    6
    PolygonPlankton ($0 - $9)1344
    7
    OptimismShark ($1,000 - $9,999)14
    8
    EthereumPlankton ($0 - $9)404
    9
    OptimismFish ($10 - $99)7832
    10
    BSCUnknown1097
    11
    EthereumShark ($1,000 - $9,999)494
    12
    OptimismDolphin ($100 - $999)327
    13
    BSCPlankton ($0 - $9)2775
    14
    EthereumDolphin ($100 - $999)1045
    15
    ArbitrumShark ($1,000 - $9,999)115
    16
    OptimismPlankton ($0 - $9)6360
    17
    BaseDolphin ($100 - $999)7432
    18
    EthereumUnknown14
    19
    PolygonFish ($10 - $99)164
    20
    BaseUnknown1719
    34
    1KB
    66s