symbol AS "Tokens"

, Count(*) AS "Transactions"

, Count(DISTINCT origin_from_address) AS "Swappers"

, SUM(CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END) AS "Volume"

FROM (

SELECT

platform

, symbol_in AS symbol

, origin_from_address

, pool_name

, amount_in_usd

, amount_out_usd

FROM avalanche.defi.ez_dex_swaps

WHERE platform = 'woofi'

UNION ALL

SELECT

platform

, symbol_out AS symbol

, origin_from_address

, pool_name

, amount_in_usd

, amount_out_usd

FROM avalanche.defi.ez_dex_swaps

WHERE platform = 'woofi'

GROUP BY 1

HAVING "Volume" > 0

ORDER BY 4 DESC

LIMIT 25