date_trunc('day', block_timestamp) as day,

count(DISTINCT tx_hash),

sum(amount_in_usd),

COUNT(DISTINCT origin_from_address)

FROM ethereum.core.ez_dex_swaps

WHERE pool_name like '%WETH%'

AND block_timestamp > '2022-08-01'

GROUP BY 1