SalehIL Protection Over Time
    Updated 2022-05-16
    with lst_recent as (
    select
    block_timestamp::date as day
    ,sum( IL_PROTECTION_USD ) as amount_usd
    from thorchain.liquidity_actions
    where IL_PROTECTION_USD>0
    and day>='2022-05-06' --The beginning of winter
    group by 1
    order by 1
    )
    , lst_Before as (
    select
    block_timestamp::date as day
    ,sum( IL_PROTECTION_USD ) as amount_usd
    from thorchain.liquidity_actions
    where IL_PROTECTION_USD>0
    and day<'2022-05-06' and day>=date('2022-05-06')-11
    group by 1
    order by 1
    )
    select 'Winter' as Type,* from lst_recent
    union all
    select 'Spring' as Type,* from lst_before

    Run a query to Download Data