i_danKaia Chain Swaps: Top trades
    Updated 2025-02-26
    SELECT
    MAX(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) as "Volume Traded"
    , left(origin_from_address, 5)||'...'||right(origin_from_address, 5) AS "User"
    FROM kaia.defi.ez_dex_swaps
    WHERE block_timestamp >= '2025-01-01'
    AND (CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) IS NOT NULL
    GROUP BY 2
    ORDER BY 1 DESC
    LIMIT 10
    Last run: 16 days ago
    Volume Traded
    User
    1
    270714.430x888...dbc9d
    2
    269437.440x2d2...40833
    3
    200699.050x379...46f1f
    4
    199199.150xde9...67337
    5
    184189.350x6c6...e3fb6
    6
    172563.470x756...4a30c
    7
    162465.760xbc2...ed4ba
    8
    132673.440x7cb...448d5
    9
    123899.750x9b4...7ee62
    10
    113509.510xe46...02c98
    10
    281B
    1s