KuramaTB - LUNA & Drawdowns - Liquidation cascades
Updated 2022-04-12
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
-- we'll consider a threshold of 100k Luna liquidated as a significant liquidation amount
select date_trunc('day', block_timestamp) as date, case when liquidated_currency = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' then 'Luna'
else 'Ethereum' end as Liquidated_currency_translated, sum(liquidated_amount) as liq_am, case when liq_am > 100000 then 'Liq_cascade' else 'Nonliq_cascade' end as liq_type,
case when liq_type = 'Liq_cascade' then 1
else -1
end as liq_type_numeric
from anchor.liquidations
where date_trunc('day', block_timestamp) >= '2021-01-01'
and liquidated_currency = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp'
group by 1, 2
-- we'll consider a threshold of 100k Luna liquidated as a significant liquidation amount
Run a query to Download Data