nitsAnchor Collateral
    Updated 2022-01-29
    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