with rETH as (select
block_timestamp,
pool_name,
SUM(IFF(SYMBOL_IN IN ('rETH', 'wrETH'), amount_in_usd, 0)) as "reth sell volume",
SUM(IFF(SYMBOL_OUT IN ('rETH', 'wrETH'), amount_out_usd, 0)) as "reth buy volume"
from ethereum.core.ez_dex_swaps
where symbol_in like '%rETH%'
and amount_in_usd>0
and block_timestamp >= '2022-01-01'
group by 1,2)
SELECT
pool_name,
sum("reth sell volume")+sum("reth buy volume") as "total swap volume"
from rETH
group by 1