nits Top 10 Liquidity Providers Fees in the Past year
Updated 2022-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with top_10_liquidity_pairs as (select pool_name as pn, sum(amt_net) as liquidity_net from (select *, case when direction = 'IN' then amount_usd else amount_usd *(-1) end as amt_net from ethereum.dex_swaps
where platform = 'sushiswap' and amount_usd is not NULL and pool_name != 'ARCX-WETH LP' and pool_name != 'WETH-CUT LP' and pool_name != 'OHM-WETH LP')
group by pool_name
order by liquidity_net desc
limit 10)
select * from
(select pool_name, sum(amount_usd)/pow(10,3)*0.25/100 as fees_in_K from
(select * from ethereum.dex_swaps
where pool_name in (select pn from top_10_liquidity_pairs) and timestampdiff(SQL_TSI_DAY,block_timestamp, CURRENT_TIMESTAMP)<366 )
GROUP by pool_name
)
order by fees_in_K desc
Run a query to Download Data