Kaskoazul90 day collateral
    Updated 2022-02-02
    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