samUntitled Query
Updated 2022-08-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
25
›
⌄
-- outstanding loan no repayments yet
with raw as (
select
origin_from_address,
lending_pool_address,
symbol
from ethereum.sushi.ez_borrowing
where action = 'Borrow'
except
select
origin_from_address,
lending_pool_address,
symbol
from ethereum.sushi.ez_borrowing
where action = 'Repay'
)
select* from raw
--select* from ethereum.sushi.ez_borrowing
--where origin_from_address = '0xff2779e68e24b725c625f514acb36736a23391e8'
--where tx_hash = '0x0aa96fbb75fd403dddde5e38bb321b20eca0c7449348227bd455bfa0a7933c40'
Run a query to Download Data