select
date_trunc('day',block_timestamp) as date,
platform as Dex,
count(tx_id) as Swaps,
sum(amount_usd) as Volume_USD,
count(DISTINCT(pool_address)) as Pools
from ethereum.dex_swaps
where
date > '2022-01-01' AND
amount_usd < 1000000000
AND platform != 'curve'
AND platform != 'uniswap-v2'
group by date, Dex
order by date