boomer77Average Loan COMP
    Updated 2021-11-10
    WITH Average_Loan as (SELECT sum(loan_amount_usd) as Average_USD, DATE_trunc('month', block_timestamp) as Balance_Month
    FROM compound.borrows
    GROUP BY Balance_Month)


    SELECT * FROM Average_Loan
    WHERE balance_month BETWEEN '2021-01-01' and '2021-06-01'
    ORDER BY balance_month DESC
    Run a query to Download Data