platform as dex,

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,

sum(iff(token_in = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_in, 0)) as swap_in_volume,

sum(iff(token_out = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_out, 0)) as swap_out_volume,

avg(iff(token_in = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_in, 0)) as swap_in_avg_volume,

avg(iff(token_out = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_out, 0)) as swap_out_avg_volume,

swap_in_volume - swap_out_volume as net_volume,

sum(iff(token_in = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_in_usd, 0)) as swap_in_volume_usd,

sum(iff(token_out = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_out_usd, 0)) as swap_out_volume_usd,

avg(iff(token_in = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_in_usd, 0)) as swap_in_avg_volume_usd,

avg(iff(token_out = '0x92d6c1e31e14520e676a687f0a93788b716beff5', amount_out_usd, 0)) as swap_out_avg_volume_usd,

swap_in_volume_usd - swap_out_volume_usd as net_volume_usd

from ethereum.core.ez_dex_swaps

where block_timestamp > current_date - 90

and '0x92d6c1e31e14520e676a687f0a93788b716beff5' in (token_in, token_out)

group by dex