platform,

count(DISTINCT tx_hash) as nb_swaps

FROM ethereum.defi.ez_dex_swaps

WHERE

block_timestamp::date >= CURRENT_DATE - 31

AND

platform in ('uniswap-v2', 'uniswap-v3')

GROUP BY platform

;