DATE_TRUNC('{{granularity }}', BLOCK_TIMESTAMP) AS date,

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 swap,

FROM avalanche.defi.ez_dex_swaps

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

group by 1,2