mariyaUST depegging in the Solana ecosystem
Updated 2022-05-18
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
›
⌄
with anchor_deposit as (select
date_trunc('day', block_timestamp) as day,
sum(deposit_amount) as deposit_anchor
from anchor.deposits
where block_timestamp > CURRENT_DATE - 90
group by 1),
ust as(SELECT
date as day,
sum(BALANCE) as total_ust
from terra.daily_balances
where CURRENCY='UST'
and date > CURRENT_DATE - 90
group by 1)
select
anchor_deposit.day as day1,
deposit_anchor,
total_ust,
total_ust-deposit_anchor as UST_despite_anchor,
sum(total_ust) over (order by day1) as "Total UST growth",
sum(UST_despite_anchor) over (order by day1) as "Total UST growth-despite anchor"
from anchor_deposit
inner join ust on anchor_deposit.day=ust.day group by 1,total_ust,deposit_anchor
Run a query to Download Data