flipside

    il percentage
    boomer77il percentage
    Updated 2022-04-12
    with raw as (select *, (rune_amount_usd+asset_amount_usd) as vol, CASE
    when il_protection_usd = 0 then 'NO IL'
    else 'YES IL' end as IL
    from thorchain.liquidity_actions
    where lp_action = 'remove_liquidity' and il_protection_usd > 0)

    select *
    from raw
    Run a query to Download Data