banbannardFailure Rate on Sushiswap 4
Updated 2022-10-02
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
31
32
33
34
35
36
›
⌄
with kashi as
(select contract_address
from ethereum.core.fact_event_logs
where contract_name ilike '%kashi%'
union
select origin_to_address
from ethereum.core.fact_event_logs
where contract_name ilike '%kashi%'
union
select
lending_pool_address
from ethereum.sushi.ez_lending
union
select
lending_pool_address
from ethereum.sushi.ez_borrowing),
base as (select
split(text_signature, '(')[0]::string as event_name,
case
when event_name ilike 'LogAddAsset%' then 'Add Asset to Bentobox'
when event_name ilike 'LogRemoveAsset%' then 'Remove Asset from Bentobox'
when event_name ilike 'adda%' then 'Add Collateral'
when event_name ilike 'RemoveCollateral%' then 'Remove Collateral'
when event_name ilike 'Removeasset%' then 'Remove Collateral'
when event_name ilike 'Borrow%' then 'Borrow Assets'
when event_name ilike 'lend%' then 'Lend Assets'
when event_name ilike 'repay%' then 'Repay Loans'
when event_name ilike 'Mint%' then 'Add Liquidity'
when event_name ilike 'Addl%' then 'Add Liquidity'
when event_name ilike 'Burn%' then 'Remove Liquidity'
when event_name ilike 'Removel%' then 'Remove Liquidity'
when event_name ilike 'Swap%' then 'Swapping'
when event_name ilike 'accrue%' then 'Accrue'
when event_name ilike 'cook%' then 'Deposit to Bentobox'
else 'no'
Run a query to Download Data