maybeyonasthor_il_daily
Updated 2022-05-15
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
last_day(block_timestamp, 'week') as date,
-- split(pool_name,'-')[0]::string as pool_name,
case when il_protection > 0 then 'protected' else 'not protected' end as il_protection,
count(distinct from_address) as users,
sum(il_protection_usd) as protection_paid
from thorchain.liquidity_actions
where lp_action = 'remove_liquidity'
-- and il_protection is null
group by 1,2--,3
-- limit 100
Run a query to Download Data