Alexaytop 10 lps
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
with txns as ( select iff(currency = 'uosmo', 'osmo', 'axl') as token, amount/1e6 as token_amount, *
from osmosis.core.fact_liquidity_provider_actions
where pool_id = '812'
and action in ('pool_joined'))
select substring(liquidity_provider_address, 1, 10) as addr, sum(token_amount) as t_amount
from txns
where token = 'axl'
group by 1
order by 2 desc
limit 10
Run a query to Download Data