0-MIDMonthly Borrow Amount(USD)
    Updated 2023-04-13
    select date_trunc('month',BLOCK_TIMESTAMP)as month,sum(LOAN_AMOUNT_USD)as borrow_amount
    , case
    when month>='2020-05-01'and month<'2021-01-01' then '2020'
    when month>='2021-01-01'and month<'2022-01-01' then '2021'
    when month>='2020-01-01' then '2022' end as time_period
    from ethereum.compound.ez_borrows
    where month>='2020-05-01'
    group by 1
    order by 1




    Run a query to Download Data