Specterplatform swapper
    Updated 2025-02-25
    WITH savax_swaps AS (
    SELECT
    Block_timestamp,
    tx_hash,
    sender,
    platform,
    amount_in_usd,
    amount_out_usd
    FROM avalanche.defi.ez_dex_swaps
    WHERE (symbol_in = 'sAVAX' OR symbol_out = 'sAVAX')
    )

    SELECT
    platform,
    COUNT(DISTINCT sender) AS swapper,
    FROM savax_swaps
    GROUP BY platform
    ORDER BY swapper DESC;
    LIMIT 10;




    QueryRunArchived: QueryRun has been archived