gigiokobaearly-harlequin
    Updated 2025-02-09
    WITH swap_data AS (
    SELECT
    SYMBOL_IN AS token_swapped_in,
    AMOUNT_IN_USD AS swap_volume,
    ORIGIN_FROM_ADDRESS AS swapper_address
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE
    TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' -- Token being swapped to
    )
    SELECT
    token_swapped_in,
    SUM(swap_volume) AS total_swap_volume,
    COUNT(DISTINCT swapper_address) AS total_swappers
    FROM
    swap_data
    WHERE swap_volume IS NOT NULL
    GROUP BY
    token_swapped_in
    ORDER BY
    total_swap_volume DESC;


    Last run: 14 days ago
    TOKEN_SWAPPED_IN
    TOTAL_SWAP_VOLUME
    TOTAL_SWAPPERS
    1
    WAVAX14669143.733259
    2
    abcPHAR4176289.52544
    3
    USDC1855456.061107
    4
    USDt1107395.49979
    5
    WETH.e5828.9810
    6
    KET4532.42200
    7
    AUSD2201.943
    7
    165B
    3s