shahdadi-9ptm8Ylp holders
Updated 2022-06-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with a as(select
distinct from_address,
sum(rune_amount) ADD_L
from flipside_prod_db.thorchain.liquidity_actions
where lp_action='add_liquidity'
group by from_address
),b as(select
distinct from_address,
sum(rune_amount) REM_L
from flipside_prod_db.thorchain.liquidity_actions
where lp_action='remove_liquidity'
group by from_address
),c as(select
a.from_address address,
(ADD_L - REM_L) amount
from a join b on a.from_address=b.from_address
)
select count(address)
from c where amount >0
Run a query to Download Data