binhachonMIM + Anchor - Yield reserve
    Updated 2022-02-10
    with Anchor_yield_reserve as (
    select
    date,
    balance_usd
    from terra.daily_balances
    where currency = 'UST'
    and address = 'terra1tmnqgvg567ypvsvk6rwsga3srp7e3lg6u0elp8'
    ),
    Anchor_last_day_of_quarter as (
    select
    date_trunc('week', date) as quarter,
    date as last_day,
    row_number() over (partition by quarter order by last_day desc) as rownumber
    from Anchor_yield_reserve
    group by quarter, last_day
    qualify rownumber = 1
    ),
    Anchor_yield_reserve_quarter as (
    select
    quarter,
    balance_usd
    from Anchor_last_day_of_quarter
    left join Anchor_yield_reserve on date = last_day
    )
    select
    quarter,
    balance_usd,
    lag(balance_usd, 1, 0) over (order by quarter),
    balance_usd - lag(balance_usd, 1, 0) over (order by quarter) as quarter_revenue
    from Anchor_yield_reserve_quarter

    Run a query to Download Data