SELECT pool_name, sum(il_protection_usd) as il_protection_usd
FROM flipside_prod_db.thorchain.liquidity_actions
WHERE lp_action = 'remove_liquidity' AND il_protection IS NOT NULL AND il_protection!= 0 AND date(block_timestamp) BETWEEN '2022-05-08' AND '2022-05-14'
GROUP BY pool_name
ORDER BY il_protection_usd DESC