elenahoocompound_borrow
    Updated 2024-01-10

    select
    b.block_number
    , b.borrower
    , b.borrows_contract_symbol
    , b.borrows_contract_address
    , ms.borrow_apy
    , ms.supply_apy
    , ms.borrows_usd
    , ms.supply_usd
    , (ms.borrows_usd / ms.supply_usd) as utilization_rate
    from ethereum.compound.ez_borrows b
    left join ethereum.compound.ez_market_stats ms
    on ms.block_number=b.block_number
    and ms.underlying_contract=b.borrows_contract_address
    where b.borrower = '0x502cb8985b2c92a8d4bf309cdaa89de9be442708'
    order by b.block_number asc


    QueryRunArchived: QueryRun has been archived