block_timestamp::date as day,

count(distinct tx_hash) as swaps_count,

count(distinct origin_from_address) as swappers_count,

count(distinct iff(token_in = '0x92d6c1e31e14520e676a687f0a93788b716beff5', tx_hash, null)) as swaps_in_count,

count(distinct iff(token_out = '0x92d6c1e31e14520e676a687f0a93788b716beff5', tx_hash, null)) as swaps_out_count

from ethereum.core.ez_dex_swaps

where block_timestamp > current_date - 90

and '0x92d6c1e31e14520e676a687f0a93788b716beff5' in (token_in, token_out)

group by day

select avg(swaps_count) as average_swaps_count,

avg(swappers_count) as average_swappers_count,

avg(swaps_in_count) as average_swaps_in_count,

avg(swaps_out_count) as average_swaps_out_count

from t