select
pool_name,
platform as Dex,
count(tx_id) as Swaps,
sum(amount_usd) as Volume,
count(DISTINCT(pool_address)) as Pools
from ethereum.dex_swaps
where
block_timestamp >= '2021-08-01' AND
amount_usd < 1000000000
-- AND platform != 'curve'
group by pool_name, Dex
order by Volume DESC
limit 20