SELECT DISTINCT pool_address as pool,
avg(liquidity_adjusted) as li
FROM ethereum.uniswapv3.ez_swaps
WHERE (token0_symbol ilike 'USDC' or token1_symbol ilike 'USDC')
AND block_timestamp::date >= current_date-30
GROUP BY pool
ORDER BY li DESC
LIMIT 10