boomer77il ins
Updated 2022-04-12
9
1
2
3
4
5
6
7
8
9
›
⌄
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')
select pool_name, IL, count(tx_id), sum(vol) as vol_usd
from raw
group by 1,2
Run a query to Download Data