COUNT(DISTINCT tx_hash) AS number_of_sales,

COUNT(DISTINCT origin_from_address) AS number_of_users,

SUM(amount_in) AS total_amount,

SUM(amount_in_usd) AS total_amount_usd,

(CASE

WHEN block_number >= '15537351' THEN 'After ETH Merge'

WHEN block_number < '15537351' THEN 'Before ETH Merge'

END

) AS label

FROM ethereum.core.ez_dex_swaps

WHERE symbol_in = 'WETH'

AND block_timestamp::DATE >= '2022-09-01'

GROUP BY 1, 6

ORDER BY 1