pool_address,

pool_name,

SUM(amount0_usd + amount1_usd) as fees,

date_trunc('day', block_timestamp) as DATE

from uniswapv3.position_collected_fees

where date <= '2021-07-18'

group by 1,2,4

having fees > 0

Order by fees DESc