select case when platform ilike '%joe%' then 'Trader Joe'

when platform ilike '%uniswap%' then 'Uniswap'

when platform ilike '%kyberswap%' then 'Kyberswap'

when platform ilike '%hashflow%' then 'Hashflow'

else initcap (platform) end as "DEX",

pool_name,

sum (amount_in_usd) as volume,

avg (amount_in_usd) as avgvolume,

count (distinct tx_hash) as transactions,

count (distinct origin_from_address) as users

from avalanche.defi.ez_dex_swaps

where "DEX" ilike '%{{Project_Name}}%'

group by 1,2 having volume > 0

order by volume DESC

limit 10)

select date_trunc ({{Time_Interval}},block_timestamp) as date,

case when platform ilike '%joe%' then 'Trader Joe'

when platform ilike '%uniswap%' then 'Uniswap'

when platform ilike '%kyberswap%' then 'Kyberswap'

when platform ilike '%hashflow%' then 'Hashflow'

else initcap (platform) end as "DEX",

pool_name,

sum (amount_in_usd) as volume,

avg (amount_in_usd) as avg_volume,

count (distinct tx_hash) as transactions,

count (distinct origin_from_address) as users

from avalanche.defi.ez_dex_swaps

where "DEX" ilike '%{{Project_Name}}%'

and pool_name in (select distinct pool_name from toppools)

group by 1,2,3

order by date