ACTION | TOTAL_TRANSACTIONS | TOTAL_USERS | TOTAL_AMOUNT_USD | AVG_AMOUNT_USD | |
|---|---|---|---|---|---|
1 | Withdraw | 38407 | 15505 | 799926354.67 | 19644.074425235 |
2 | Deposit | 100057 | 42082 | 906466443.78 | 8484.335864657 |
damidezsupply lending
Updated 2025-02-10
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
›
⌄
WITH TransferEvents AS (
SELECT block_timestamp, tx_hash,
depositor AS user, amount_usd, event_name AS Action
FROM avalanche.defi.ez_lending_deposits
WHERE amount is not null
AND token_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND contract_address = '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb'
AND platform = 'Benqi'
AND event_name = 'Deposit'
--AND TX_HASH = '0x0dd162f0a21f63b543e64f8ce36fe28f71dbf5445c6630df8c80b9006721bda0'
UNION ALL
SELECT block_timestamp, tx_hash,
depositor AS user, amount_usd, event_name As Action
FROM avalanche.defi.ez_lending_withdraws
WHERE amount is not null
AND token_address = '0x2b2c81e08f1af8835a78bb2a90ae924ace0ea4be'
AND contract_address = '0xf362fea9659cf036792c9cb02f8ff8198e21b4cb'
AND platform = 'Benqi'
AND event_name = 'Withdraw'
)
SELECT Action,
COUNT(DISTINCT tx_hash) AS total_transactions,
COUNT(DISTINCT user) AS total_users,
SUM(amount_usd) AS total_amount_usd,
AVG(amount_usd) AS avg_amount_usd
FROM TransferEvents
GROUP BY action;
Last run: 2 months ago
2
108B
3s