sum(amount_in_usd) as swap_from_rETH_USD_volume

FROM ethereum.core.ez_dex_swaps

where days >= '2022-01-01'

and symbol_in in ('rETH')

group by 1

),

buy as (select date_trunc('day', block_timestamp) as days,

sum(amount_out_usd) as swap_to_rETH_USD_volume

FROM ethereum.core.ez_dex_swaps

where days >= '2022-01-01'

and symbol_out in ('rETH')

group by 1

)

select x.days,

swap_from_rETH_USD_volume,

swap_to_rETH_USD_volume

from sell x

join buy y

on x.days = y.days