Kaskoazul90 day collateral
Updated 2022-02-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
date_trunc('DAY', block_timestamp) as DATE,
contract_label,
--event_type,
sum(amount) as total_amount,
sum(amount_usd) as total_amount_usd,
count(tx_id) as total_transactions
FROM
anchor.collateral
WHERE
DATE > CURRENT_DATE - 90
AND event_type = 'provide'
AND contract_label = 'bETH mmCustody'
GROUP BY 1, 2
ORDER BY 1 DESC
Run a query to Download Data