select
pool_address,
pool_name,
sum(amount0_usd + amount1_usd) as fees,
date_trunc('day', block_timestamp) as date
FROM
ethereum.uniswapv3.ez_position_collected_fees
WHERE
date >= '2023-07-01'
GROUP BY
1,
2,
4
HAVING
fees > 0
and fees < 1e20
ORDER BY
fees DESC
LIMIT
1000