count(DISTINCT origin_from_address) as user_count,

count(DISTINCT tx_hash) as tx_count,

sum(amount_in_usd) as total_vol,

count(distinct pool_name) as pool_count,

count(distinct platform) as dex_count,

count(distinct symbol_in) as symbol_in_count,

count(distinct symbol_out) as symbol_out_count,

avg(amount_in_usd) as avg_tx_vol,

from

avalanche.defi.ez_dex_swaps

where

block_timestamp::date >= '2025-01-01'