select block_timestamp::date as date

, platform

, symbol_in

, symbol_out

, amount_in_usd

, amount_out_usd

from ethereum.core.ez_dex_swaps

where block_timestamp between '2021-01-01' and '2022-09-30'

and event_name = 'Swap'

and (symbol_in = 'WETH' or symbol_out = 'WETH')

select date_trunc('month', date) as "Month"

, platform as "DEX"

, sum(amount_in_usd) as "Swap Volume ($)"

, sum(amount_out_usd) as sum_amount_out_usd

from swap_eth

group by 1, 2

order by 1