-- forked from sadegh_golandam / big pool uniswap @ https://flipsidecrypto.xyz/sadegh_golandam/q/2023-05-01-07-11-pm-D6-8wz
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