SELECT

time_period,

avg(swaps),

avg(users),

avg(swap_volume_usd )

FROM (

SELECT

date_trunc('day', block_timestamp) as day,

CASE WHEN block_number BETWEEN 16310000 AND 16420000 THEN 'Uptrend Time Period'

ELSE 'Other Time Period' END as time_period,

COUNT(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users,

sum(CASE WHEN amount_in_usd BETWEEN amount_out_usd * 0.5 and amount_out_usd * 2 THEN amount_in_usd ELSE 0 END) as swap_volume_usd

FROM ethereum.core.ez_dex_swaps

WHERE ( symbol_in LIKE 'WETH'

OR symbol_out LIKE 'WETH' )

AND block_timestamp > '2022-06-01'

GROUP BY 1,2

GROUP BY 1