N_TXS | N_USERS | |
|---|---|---|
1 | 3056946 | 697450 |
0xHaM-dLending Total
Updated 2025-05-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with lendingTb as (
SELECT
BLOCK_TIMESTAMP,
TX_HASH,
sender as user
FROM aptos.core.fact_events a
JOIN aptos.core.fact_transactions b using(BLOCK_TIMESTAMP,TX_HASH)
WHERE EVENT_ADDRESS = '0x9770fa9c725cbd97eb50b2be5f7416efdfd1f1554beb0750d4dae4c64e860da3'
AND EVENT_MODULE = 'controller'
AND EVENT_RESOURCE ilike ANY ('DepositEvent%','EndFlashLoanEvent%','WithdrawEvent%','BeginFlashLoanEvent%','ClaimRewardEvent%','LiquidateEven%')
AND TX_TYPE = 'user_transaction'
)
SELECT
count(DISTINCT TX_HASH) as n_txs,
count(DISTINCT user) as n_users
FROM lendingTb
Last run: 21 days ago
1
18B
184s