Sandeshsushi lending failure
Updated 2022-10-03
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
26
27
28
29
30
›
⌄
with borrow_contracts as
(
select
distinct borrows.origin_to_address,
contr_data.symbol
from ethereum.sushi.ez_borrowing borrows
left join
ethereum.core.dim_contracts contr_data
on borrows.origin_to_address=contr_data.address
),
borrow_data AS
(
select
f.block_timestamp,
f.tx_hash,
f.from_address,
f.to_address,
b.symbol,
f.gas_price,
f.CUMULATIVE_GAS_USED,
f.status
from ethereum.core.fact_transactions f
right join borrow_contracts b
on f.to_address = b.origin_to_address
where f.status is not null
and b.symbol is not null
)
select * from borrow_data
Run a query to Download Data