avg(transaction),

avg(active_users),

avg(swap_volume_USD)

from (

SELECT

date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_hash) as transaction,

count(DISTINCT ORIGIN_FROM_ADDRESS) as active_users,

sum(CASE when not amount_in_usd is NULL then AMOUNT_IN_USD

when not amount_out_usd is NULL then AMOUNT_OUT_USD

else 0 end) as swap_volume_USD

FROM gnosis.sushi.ez_swaps

GROUP BY 1

HAVING day > '2022-01-01'

)