nitsTop 10 Liquidity Providers Volume in the Past 7 days
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, 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,6) as volume_in_M from
(select * from ethereum.dex_swaps
where pool_name in (select pool_name from top_10_liquidity_pairs) and timestampdiff(SQL_TSI_DAY,block_timestamp, CURRENT_TIMESTAMP)<7 )
GROUP by pool_name
)
order by volume_in_M desc
Run a query to Download Data