Avergae Flashloan (USD) | Maximum Flashloan (USD) | Median Flashloan (USD) | Average Flashloan per Borrower | |
|---|---|---|---|---|
1 | 251114.306391582 | 104893247.35 | 3902.905 | 14.183036 |
Mrftiexpensive-peach copy
Updated 17 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
›
⌄
-- forked from expensive-peach @ https://flipsidecrypto.xyz/studio/queries/0489b85f-54b9-4872-8bce-2656943dd105
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
)
select
avg ("Total Flashloan (USD)") as "Avergae Flashloan (USD)",
max ("Total Flashloan (USD)") as "Maximum Flashloan (USD)",
median ("Total Flashloan (USD)") as "Median Flashloan (USD)",
sum ("Total Flashloans") / count (distinct "Borrower") as "Average Flashloan per Borrower"
from tbl
Last run: about 17 hours agoAuto-refreshes every 12 hours
1
52B
3s