datavortexplatform dependencies
    Updated 2025-05-18
    WITH platform_token_activity AS (
    SELECT
    platform,
    symbol_in,
    COUNT(DISTINCT tx_id) AS total_swap_count
    FROM
    sei.defi.ez_dex_swaps
    WHERE
    symbol_in IS NOT NULL
    GROUP BY
    platform, symbol_in
    ),
    ranked_platform_tokens AS (
    SELECT
    platform,
    symbol_in,
    total_swap_count,
    ROW_NUMBER() OVER (PARTITION BY platform ORDER BY total_swap_count DESC) AS rank
    FROM
    platform_token_activity
    )
    SELECT
    platform,
    symbol_in,
    total_swap_count
    FROM
    ranked_platform_tokens
    WHERE
    rank <= 5
    ORDER BY
    platform, total_swap_count DESC;

    Last run: 13 days ago
    PLATFORM
    SYMBOL_IN
    TOTAL_SWAP_COUNT
    1
    astroportSEI706391
    2
    astroportUSDCet133408
    3
    astroportSEIYAN108757
    4
    astroportUSDC58881
    5
    astroportUSDT35202
    6
    dragonswapWSEI2588166
    7
    dragonswapUSDC1340734
    8
    dragonswapUSDT650350
    9
    dragonswapiSEI405135
    10
    dragonswapWETH351935
    11
    fuzioSEI3592
    12
    fuzioUSDCet1431
    13
    fuzioWETH1235
    14
    fuzioATOM286
    15
    fuzioOSMO205
    16
    jellyswapUSDC706715
    17
    jellyswapWSEI480184
    18
    jellyswapfastUSD229031
    19
    jellyswapUSDT188322
    20
    jellyswapJLY165490
    30
    797B
    3s