datavortexTop Swapped by category
    Updated 2025-04-30
    WITH user_volumes AS (
    SELECT
    trader,
    SUM(amount_in_usd) AS total_volume
    FROM
    near.defi.ez_dex_swaps
    WHERE
    platform = 'v2.ref-finance.near'
    AND amount_in_usd IS NOT NULL
    GROUP BY
    trader
    ),
    categorized_traders AS (
    SELECT
    trader,
    CASE
    WHEN total_volume >= 100000 THEN 'Whales (100k+)'
    WHEN total_volume BETWEEN 50000 AND 99999 THEN 'Dolphins (50k-100k)'
    WHEN total_volume BETWEEN 10000 AND 49999 THEN 'Big Fish (10k-50k)'
    WHEN total_volume BETWEEN 5000 AND 9999 THEN 'Tuna (5k-10k)'
    WHEN total_volume BETWEEN 1000 AND 4999 THEN 'Salmon (1k-5k)'
    WHEN total_volume BETWEEN 500 AND 999 THEN 'Trout (500-1k)'
    WHEN total_volume BETWEEN 100 AND 499 THEN 'Goldfish (100-500)'
    WHEN total_volume BETWEEN 10 AND 99 THEN 'Minnows (10-100)'
    ELSE 'Plankton (<10)'
    END AS category
    FROM user_volumes
    ),
    category_top_tokens AS (
    SELECT
    ct.category,
    s.symbol_in,
    COUNT(DISTINCT s.tx_hash) AS swaps
    FROM
    near.defi.ez_dex_swaps s
    JOIN categorized_traders ct ON s.trader = ct.trader
    Last run: 28 days ago
    CATEGORY
    TOP_SWAPPED_TOKEN
    SWAPS
    1
    Big Fish (10k-50k)USDt94670
    2
    Big Fish (10k-50k)wNEAR647141
    3
    Big Fish (10k-50k)NEKO112599
    4
    Dolphins (50k-100k)BLACKDRAGON87304
    5
    Dolphins (50k-100k)wNEAR341773
    6
    Dolphins (50k-100k)REF18860
    7
    Goldfish (100-500)USDC283167
    8
    Goldfish (100-500)wNEAR1008312
    9
    Goldfish (100-500)USDt360494
    10
    Minnows (10-100)UWON273001
    11
    Minnows (10-100)USDt383861
    12
    Minnows (10-100)wNEAR1279460
    13
    Plankton (<10)USDt269209
    14
    Plankton (<10)UWON226439
    15
    Plankton (<10)wNEAR1003761
    16
    Salmon (1k-5k)USDt329775
    17
    Salmon (1k-5k)wNEAR1130454
    18
    Salmon (1k-5k)USDC277749
    19
    Trout (500-1k)USDC159991
    20
    Trout (500-1k)USDt179179
    27
    953B
    515s