Eman-RazTotal Swap Stats By DEX
    Updated 4 days ago
    select platform, count(distinct tx_hash) as "Swap Count",
    ROUND(sum(amount_in_usd),1) as "Swap Volume ($USD)",
    count(distinct origin_from_address) as "Swapper Count",
    --symbol_in || '➡' || symbol_out as token_pair,
    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}}'
    group by 1
    Last run: 4 days agoAuto-refreshes every 24 hours
    PLATFORM
    Swap Count
    Swap Volume ($USD)
    Swapper Count
    1
    pangolin6494184061.11298
    2
    pharaoh-v267452014132.91390
    3
    woofi315288682.524
    4
    trader-joe-v1179063106018051.219368
    5
    uniswap-v3264778810064.13695
    6
    balancer74051199979.31027
    7
    trader-joe-v21301292073944668
    7
    243B
    104s