date_trunc('day', block_timestamp) as date,

count(DISTINCT origin_from_address) as user_count,

count(DISTINCT tx_hash) as tx_count,

count(distinct pool_name) as pool_count,

sum(amount_in_usd) as total_vol,

avg(amount_in_usd) as avg_tx_vol

from

avalanche.defi.ez_dex_swaps

where

block_timestamp::date >= current_date - interval '30 days' and

platform IN ('trader-joe-v1', 'trader-joe-v2')

group by 1

order by 1 asc