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

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

order by date desc