keshanThorchain IL
    Updated 2022-04-10
    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