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
    QueryRunArchived: QueryRun has been archived