maybeyonasthor_il_daily
    Updated 2022-05-15
    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