nitsAnchor Collateral
Updated 2022-01-29
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select contract_label , sum(amt_net) as total_amt,
case when contract_label = 'bETH mmCustody' then total_amt*2546/pow(10,6)
else total_amt*53/pow(10,6) end as total_amount_usd_in_M
from (select * , case when event_type = 'withdraw' then amount*(-1)
when event_type = 'provide' then amount
end as amt_net
from anchor.collateral)
GROUP by contract_label
limit 100
Run a query to Download Data