nitsIL Insurance
Updated 2022-04-11
9
1
2
3
4
5
6
›
⌄
SELECT COUNT ( tx_id) as total_txs, sum(il) as total_protection,total_protection/total_txs*100 as percent_users_insured , avg(il) as avg_amt_insured
from
(SELECT * , case when IL_PROTECTION_USD> 0 then '1' else '0' end as il from thorchain.liquidity_actions
where lp_action = 'remove_liquidity' and date(block_timestamp)>= '2022-01-01' )
-- LIMIT 100
Run a query to Download Data