LTirrell20. Liquidity
Updated 2021-11-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
›
⌄
-- Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity?
select
count(
distinct (
case
when lp_action = 'add_liquidity' then from_address
end
)
) as adders,
count(
distinct (
case
when lp_action = 'remove_liquidity' then from_address
end
)
) as removers,
removers / adders as removal_ratio
from
thorchain.liquidity_actions
where
TX_ID is not null AND block_timestamp::date>current_date-30
Run a query to Download Data