main as (

tx_hash,

block_timestamp,

origin_from_address as swapper,

iff(platform ilike 'trader-joe%', 'Trader Joe', 'Other DEXs') as platform,

symbol_in,

symbol_out,

nvl(amount_in_usd,amount_out_usd) as amount_usd

from avalanche.defi.ez_dex_swaps

where amount_usd between 0 and 1e7

and block_timestamp between '{{ start_date }}' and '{{ end_date }}'

platform,

count(distinct tx_hash) as swaps,

count(distinct swapper) as swappers,

sum(amount_usd) as volume_usd,

avg(amount_usd) as average_amount_usd,

swaps / count(distinct block_timestamp::date) as daily_average_swaps,

swappers / count(distinct block_timestamp::date) as daily_average_swappers

from main

group by 1