SELECT pool_address, SUM(amount_usd)/2 AS volume_usd -- don't double count, swaps amounts going to and from the pool
FROM ethereum.dex_swaps
WHERE platform = 'uniswap-v2' AND DATE(block_timestamp) >= CURRENT_DATE - 10
-- AND pool_address = '0xb4e16d0168e52d35cacd2c6185b44281ec28c9dc'
GROUP BY 1
HAVING volume_usd IS NOT NULL
ORDER BY 2 DESC