elenahooaave_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
20
21
22
23
24
›
⌄
select
b.block_number
, b.borrower_address
--, b.borrowed_tokens
--, b.borrowed_usd
, b.borrow_rate_mode
, b.token_price
, b.symbol
, b.aave_market
--, b.aave_token
, ms.borrow_rate_stable
, ms.borrow_rate_variable
, ms.supply_rate
, ms.utilization_rate
from ethereum.aave.ez_borrows b
left join ethereum.aave.ez_market_stats ms
on ms.block_number=b.block_number
and ms.aave_market=b.aave_market
and ms.lending_pool_add=b.lending_pool_contract
where b.borrower_address = '0x99e2ae3dd7fdb5684950176551911d19d55dfcab'
order by b.block_number asc
QueryRunArchived: QueryRun has been archived