Eman-RazTop Token Pairs By Swap Volume
    Updated 2025-03-25
    select symbol_in || '➡' || symbol_out as token_pair,
    ROUND(sum(amount_in_usd),1) as "Swap Volume ($USD)"
    from avalanche.defi.ez_dex_swaps
    where (token_in=lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5') or
    token_out=lower('0xAcFb898Cff266E53278cC0124fC2C7C94C8cB9a5'))
    and block_timestamp::date between '{{Start_Date}}' and '{{End_Date}}'
    and amount_in_usd is not null
    group by 1
    order by 2 desc
    limit 10
    Last run: about 1 month ago
    TOKEN_PAIR
    Swap Volume ($USD)
    1
    NOCHILL➡WAVAX62816938.5
    2
    WAVAX➡NOCHILL61459705.5
    3
    NOCHILL➡KIMBO582412.6
    4
    USDC➡NOCHILL532236.2
    5
    KIMBO➡NOCHILL531870.1
    6
    NOCHILL➡USDC459019
    7
    COQ➡NOCHILL231326
    8
    NOCHILL➡COQ227416.1
    9
    TECH➡NOCHILL162035.1
    10
    NOCHILL➡TECH129304.6
    10
    283B
    2s