Tier | Total Borrowers | |
|---|---|---|
1 | Tier1: only 1 Flashloan | 3082 |
2 | Tier2: 2-5 Flashloans | 2791 |
3 | Tier3: 6-10 Flashloans | 727 |
4 | Tier4: 11-100 Flashloans | 1039 |
5 | Tier5: +100 Flashloans | 202 |
Mrftidoubtful-copper copy
Updated 9 hours ago
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
›
⌄
-- forked from doubtful-copper @ https://flipsidecrypto.xyz/studio/queries/16fde6ff-91f3-4eb6-8d42-ebfe2d7b42ca
with tbl as
(
select
ORIGIN_FROM_ADDRESS as "Borrower",
count (distinct tx_hash) as "Total Flashloans",
sum (FLASHLOAN_AMOUNT_USD) as "Total Flashloan (USD)"
from avalanche.defi.ez_lending_flashloans
group by 1
having sum (FLASHLOAN_AMOUNT_USD) > 0
order by 3 desc
)
SELECT
case
when "Total Flashloans" =1 then 'Tier1: only 1 Flashloan'
when "Total Flashloans" > 1 and "Total Flashloans" < 6 then 'Tier2: 2-5 Flashloans'
when "Total Flashloans" >= 6 and "Total Flashloans" < 11 then 'Tier3: 6-10 Flashloans'
when "Total Flashloans" >= 11 and "Total Flashloans" < 101 then 'Tier4: 11-100 Flashloans'
when "Total Flashloans" >= 101 then 'Tier5: +100 Flashloans' end as "Tier",
count (DISTINCT "Borrower") AS "Total Borrowers"
from tbl
group by 1
order by 1 asc
Last run: about 9 hours agoAuto-refreshes every 12 hours
5
161B
27s