SYMBOL_IN || ' / ' || SYMBOL_OUT as Pair,

CASE

WHEN PLATFORM ILIKE 'trader-joe%' THEN 'trader-joe'

WHEN PLATFORM ILIKE 'hashflow%' THEN 'hashflow'

WHEN PLATFORM ILIKE 'kyberswap%' THEN 'kyberswap'

WHEN PLATFORM ILIKE 'pharaoh%' THEN 'pharaoh'

WHEN PLATFORM ILIKE 'uniswap%' THEN 'uniswap'

ELSE PLATFORM

END AS platform_group,

SUM( AMOUNT_IN_USD ) AS volume,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS ) AS swappers,

COUNT(DISTINCT TX_HASH ) AS swaps,

FROM avalanche.defi.ez_dex_swaps

where AMOUNT_IN_USD is not null

AND block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'

GROUP BY

Pair,platform_group

ORDER BY

volume desc;