binhachonMIM + Anchor - Yield reserve
Updated 2022-02-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
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