TOKEN0_SYMBOL,

TOKEN1_SYMBOL,

COUNT(DISTINCT LIQUIDITY_PROVIDER) AS num_providers,

SUM(LIQUIDITY_ADJUSTED) AS total_liquidity,

SUM(LIQUIDITY_ADJUSTED) / COUNT(DISTINCT LIQUIDITY_PROVIDER) AS avg_liquidity_per_provider

FROM

ethereum.uniswapv3.ez_lp_actions

GROUP BY

TOKEN0_SYMBOL,

TOKEN1_SYMBOL

ORDER BY

num_providers DESC,

avg_liquidity_per_provider ASC

LIMIT 10;