platform,

count(distinct tx_hash) n_swaps

FROM ethereum.defi.ez_dex_swaps

WHERE block_timestamp :: date >= current_date - 2024-08-15

and platform like 'uniswap%'

GROUP BY platform