select BLOCK_TIMESTAMP::date DATE ,PLATFORM as Dex, sum(AMOUNT_IN_USD) as volume_swap, count(DISTINCT TX_HASH) as swap,
count(distinct ORIGIN_FROM_ADDRESS) as Swapper
from ethereum.core.ez_dex_swaps
where Date >= '2022-01-01'
and platform not in ('curve')
group by 1,2