select
date_trunc('day',block_timestamp) as block_day,
sum(amount0_usd) + sum(amount1_usd) as fees
from
uniswapv3.position_collected_fees
where amount0_usd is not null and amount1_usd is not null and block_day between '2021-07-02' and '2021-08-02'
group by 1
order by 1 desc