keshanThorchain IL
Updated 2022-04-10
9
1
2
3
4
5
6
›
⌄
select *, "Number of IL Receptions"*100/"Number of Removals" as Percentage
from
(select pool_name, count(distinct tx_id) as "Number of Removals", sum(case when il_protection > 0 then 1 else 0 end) as "Number of IL Receptions"
from thorchain.liquidity_actions where lp_action = 'remove_liquidity'
group by pool_name)
Run a query to Download Data