LIQUIDITY_PROVIDER,

SUM(AMOUNT0_ADJUSTED + AMOUNT1_ADJUSTED) AS TotalVolume,

CASE

WHEN TotalVolume >= (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY TotalVolume) FROM (SELECT LIQUIDITY_PROVIDER, SUM(AMOUNT0_ADJUSTED + AMOUNT1_ADJUSTED) AS TotalVolume FROM ethereum.uniswapv3.ez_lp_actions GROUP BY LIQUIDITY_PROVIDER)) THEN 'Whale'

ELSE 'Small LP'

END AS LP_Type

ethereum.uniswapv3.ez_lp_actions

GROUP BY

LIQUIDITY_PROVIDER

ORDER BY

TotalVolume DESC;