elenahoocompound_borrow
Updated 2024-01-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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