date_trunc('day', block_timestamp) as date,

pool_name,

COUNT(DISTINCT from_address) as swapers,

SUM(amount_usd) as volume

FROM ethereum.dex_swaps

WHERE pool_name LIKE '%aETH%'

and date >= '2022-01-01'

GROUP BY 1,2