KuramabETH total supply
Updated 2022-03-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with beth_deposit as (SELECT sum(amount) AS amount_beth_dep FROM anchor.collateral
WHERE currency = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' AND event_type = 'provide'),
beth_withdrawn as (SELECT sum(amount) AS amount_beth_with FROM anchor.collateral
WHERE currency = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun' AND event_type = 'withdraw'),
beth_liquidations as (select sum(liquidated_amount) as beth_liq from anchor.liquidations
where liquidated_currency = 'terra1dzhzukyezv0etz22ud940z7adyv7xgcjkahuun'),
total_amount as (select (amount_beth_dep-amount_beth_with+beth_liq) as total_supply,
(amount_beth_dep-amount_beth_with-beth_liq) as supply_for_borrowing,
((amount_beth_dep-amount_beth_with-beth_liq)/(amount_beth_dep-amount_beth_with+beth_liq))*100 as Percent_as_collateral
from beth_deposit
join beth_withdrawn
join beth_liquidations)
Run a query to Download Data