date_trunc('week',block_timestamp) as week,

pool_name,

pool_address,

round(sum(amount0_adjusted + amount1_adjusted),4) as fees_collected

FROM uniswapv3.position_collected_fees

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

AND pool_name LIKE 'USDC-USDT%'

OR pool_name LIKE 'USDC-WETH%'

OR pool_name LIKE 'WETH-USDC%'

OR pool_name LIKE 'UNI-WETH%'

OR pool_name LIKE 'AXS-WETH%'

OR pool_name LIKE 'DAI-USDC%'

OR pool_name LIKE 'FEI-USDC%'

OR pool_name LIKE 'DAI-WETH%'

OR pool_name LIKE 'WBTC-WETH%'

OR pool_name LIKE 'SHIBA2-WETH%'

GROUP BY week, pool_address, pool_name

HAVING fees_collected > 1

ORDER BY WEEK