mr_dTraders rank on aptos dex protocols
    Updated 2025-05-12
    With wallet_txs AS (
    SELECT
    platform
    , swapper
    , Count(tx_hash) AS txs
    , CASE WHEN txs <= 2 THEN 'A - One Time Trader'
    WHEN txs > 1 AND txs <= 10 THEN 'B - Avid Trader'
    WHEN txs > 10 AND txs <= 50 THEN 'C - Active Trader'
    WHEN txs > 50 AND txs <= 100 THEN 'D - Ultra-Active Trader'
    WHEN txs > 100 THEN 'E - Master Trader' END AS Trader_Rank
    FROM aptos.defi.ez_dex_swaps
    GROUP BY 1, 2
    )

    SELECT
    platform
    , trader_rank
    , COUNT(DISTINCT swapper) AS traders
    FROM wallet_txs
    GROUP BY Platform, Trader_rank
    ORDER BY Platform, Trader_rank desc
    Last run: about 1 month ago
    PLATFORM
    TRADER_RANK
    TRADERS
    1
    animeswapE - Master Trader711
    2
    animeswapD - Ultra-Active Trader594
    3
    animeswapC - Active Trader10925
    4
    animeswapB - Avid Trader43471
    5
    animeswapA - One Time Trader78945
    6
    auxexchangeE - Master Trader686
    7
    auxexchangeD - Ultra-Active Trader435
    8
    auxexchangeC - Active Trader7784
    9
    auxexchangeB - Avid Trader45977
    10
    auxexchangeA - One Time Trader99607
    11
    batswapE - Master Trader102
    12
    batswapD - Ultra-Active Trader117
    13
    batswapC - Active Trader923
    14
    batswapB - Avid Trader7963
    15
    batswapA - One Time Trader18952
    16
    cellanaE - Master Trader9289
    17
    cellanaD - Ultra-Active Trader3948
    18
    cellanaC - Active Trader32959
    19
    cellanaB - Avid Trader110165
    20
    cellanaA - One Time Trader455045
    60
    2KB
    44s