date_trunc('day',block_timestamp) as day,

pool_address,

pool_name,

sum(amount0_adjusted + amount1_adjusted) as fees_collected

FROM uniswapv3.position_collected_fees

WHERE block_timestamp >= getdate() - interval '30 days'

GROUP BY day, pool_address, pool_name

HAVING fees_collected > 10000

ORDER BY DAY