theericstoneTop Uniswap Moneymakers
Updated 2022-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with winners as (
select liquidity_provider as address,
sum(amount0_usd) as amount0_earned,
sum(amount1_usd) as amount1_earned,
coalesce(amount0_earned,0) + coalesce(amount1_earned,0) as amount_earned
from
uniswapv3.position_collected_fees
where block_timestamp > current_date - 14
group by 1
order by 4 desc
),
rankwins as (
select winners.*,
rank() over (order by amount_earned desc) as rank
from winners
)
select * from rankwins where rank < 101 order by 4 desc;
Run a query to Download Data