Tier | Total Borrowers | |
|---|---|---|
1 | Tier1: Less Than $1 | 197 |
2 | Tier2: $1-10 | 295 |
3 | Tier3: $10-100 | 610 |
4 | Tier4: $100-1000 | 1521 |
5 | Tier5: $1k-10k | 2246 |
6 | Tier6: > $10k | 2972 |
Mrftidoubtful-copper
Updated 10 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
›
⌄
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 Flashloan (USD)" < 1 then 'Tier1: Less Than $1'
when "Total Flashloan (USD)" >= 1 and "Total Flashloan (USD)" < 10 then 'Tier2: $1-10'
when "Total Flashloan (USD)" >= 10 and "Total Flashloan (USD)" < 100 then 'Tier3: $10-100'
when "Total Flashloan (USD)" >= 100 and "Total Flashloan (USD)" < 1000 then 'Tier4: $100-1000'
when "Total Flashloan (USD)" >= 1000 and "Total Flashloan (USD)" < 10000 then 'Tier5: $1k-10k'
when "Total Flashloan (USD)" >= 10000 then 'Tier6: > $10k' end as "Tier",
count (DISTINCT "Borrower") AS "Total Borrowers"
from tbl
group by 1
order by 1 asc
Last run: about 10 hours agoAuto-refreshes every 12 hours
6
146B
1s