flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
5 users that have most deposited
eslamis-darkat
5 users that have most deposited
Updated 2022-09-28
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
select
LIQUIDITY_PROVIDER_ADDRESS
,
AMOUNT
/
1e6
as
axl_amount
from
osmosis
.
core
.
fact_liquidity_provider_actions
where
POOL_ID
=
'812'
and
CURRENCY
!=
'uosmo'
and
TX_STATUS
=
'SUCCEEDED'
and
ACTION
=
'pool_joined'
ORDER
BY
axl_amount
DESC
limit
5
Results
Run a query to Download Data