Afonso_Diaz2023-10-18 05:25 PM
Updated 2023-10-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
with t as (
SELECT
LIQUIDITY_PROVIDER,
SUM(AMOUNT0_USD + AMOUNT1_USD) AS TotalVolume,
CASE
WHEN TotalVolume >= (SELECT PERCENTILE_CONT(0.9) WITHIN GROUP (ORDER BY TotalVolume) FROM (SELECT LIQUIDITY_PROVIDER, SUM(AMOUNT0_USD + AMOUNT1_USD) AS TotalVolume FROM ethereum.uniswapv3.ez_lp_actions GROUP BY LIQUIDITY_PROVIDER)) THEN 'Whale'
ELSE 'Small LP'
END AS LP_Type
FROM
ethereum.uniswapv3.ez_lp_actions
where action = 'INCREASE_LIQUIDITY'
GROUP BY
LIQUIDITY_PROVIDER
having TotalVolume between 0 and 1e9
)
select
lp_type,
count(distinct liquidity_provider) as liquidity_provider,
sum(TotalVolume) as volume_usd,
avg(TotalVolume) as average_volume_usd,
median(TotalVolume) as median_volume_usd
from t
group by 1
Run a query to Download Data