Lending transactions | DEPOSITORS | Pools | Net Lending Volume-USD | MAX.Lending Volume-USD | AVG.Lending Volume-USD | |
|---|---|---|---|---|---|---|
1 | 196812 | 26825 | 14 | 128043090.78 | 15391488.21 | 611.33594391 |
SalehTotal
Updated 2025-01-27
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
›
⌄
with lst_deposit as (
select
block_timestamp::date as date
,tx_hash
,DEPOSITOR
,TOKEN_SYMBOL
,AMOUNT_USD
from avalanche.defi.ez_lending_deposits
where year(block_timestamp) = '2024'
and PLATFORM='Benqi'
)
,lst_withdraw as (
select
block_timestamp::date as date
,tx_hash
,DEPOSITOR
,TOKEN_SYMBOL
,-1*AMOUNT_USD
from avalanche.defi.ez_lending_withdraws
where year(block_timestamp) = '2024'
and PLATFORM='Benqi'
)
,lst_all as (
select 'Deposit' as type, * from lst_deposit
union all
select 'Withdraw' as type, * from lst_withdraw
)
select
count(DISTINCT tx_hash) as "Lending transactions"
,count(DISTINCT DEPOSITOR) as Depositors
,count(DISTINCT TOKEN_SYMBOL) as "Pools"
,sum(AMOUNT_USD) as "Net Lending Volume-USD"
,max(AMOUNT_USD) as "MAX.Lending Volume-USD"
,avg(AMOUNT_USD) as "AVG.Lending Volume-USD"
from lst_all
Last run: 2 months ago
1
57B
2s