flipside

    LargestBorrowed
    boomer77LargestBorrowed
    Updated 2021-11-10
    WITH LargestBorrowed as (SELECT sum(loan_amount_usd) as Loan_amount, ctoken_symbol as Symbol, date_trunc('day', block_timestamp) as metric_date
    from compound.borrows
    GROUP by symbol, metric_date)

    SELECT * from LargestBorrowed
    where metric_date = (select max(metric_date) from LargestBorrowed)

    ORDER by Loan_amount DESC
    LIMIT 1

    Run a query to Download Data