STATUS | Date | N_USERS | |
|---|---|---|---|
1 | Unique Borrowers | 2024-10-18 00:00:00.000 | 16365 |
2 | Unique Borrowers | 2024-11-16 00:00:00.000 | 18791 |
3 | Unique Borrowers | 2024-06-07 00:00:00.000 | 8761 |
4 | Unique Borrowers | 2024-09-22 00:00:00.000 | 14728 |
5 | Unique Borrowers | 2024-07-05 00:00:00.000 | 10738 |
6 | Unique Borrowers | 2024-09-30 00:00:00.000 | 15184 |
7 | Unique Borrowers | 2025-04-01 00:00:00.000 | 31546 |
8 | Unique Users | 2025-04-01 00:00:00.000 | 118180 |
9 | Unique Users | 2024-07-05 00:00:00.000 | 17870 |
10 | Unique Users | 2024-10-18 00:00:00.000 | 33224 |
11 | Unique Users | 2024-06-07 00:00:00.000 | 14410 |
12 | Unique Users | 2024-11-16 00:00:00.000 | 39589 |
13 | Unique Users | 2024-09-30 00:00:00.000 | 30401 |
14 | Unique Users | 2024-09-22 00:00:00.000 | 29237 |
15 | Unique Borrowers | 2025-02-03 00:00:00.000 | 29159 |
16 | Unique Borrowers | 2025-03-12 00:00:00.000 | 30186 |
17 | Unique Borrowers | 2024-10-26 00:00:00.000 | 17221 |
18 | Unique Borrowers | 2024-03-29 00:00:00.000 | 549 |
19 | Unique Borrowers | 2024-12-29 00:00:00.000 | 27664 |
20 | Unique Borrowers | 2024-12-24 00:00:00.000 | 22327 |
0xHaM-dUsers in Total
Updated 9 days ago
999
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
36
›
⌄
WITH deposit_withdraw AS (
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
sender::STRING AS user
FROM aptos.core.fact_events
JOIN aptos.core.fact_transactions using(TX_HASH)
WHERE EVENT_TYPE IN (
'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::WithdrawEvent'
,'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::SupplyEvent'
)
AND SUCCESS = TRUE
)
,
lend_borrowe AS (
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
sender::STRING AS user
FROM aptos.core.fact_events
JOIN aptos.core.fact_transactions using(TX_HASH)
WHERE EVENT_TYPE IN (
'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::BorrowEvent'
,'0xc6bc659f1649553c1a3fa05d9727433dc03843baac29473c817d06d39e7621ba::lending::RepayEvent'
)
AND SUCCESS = TRUE
)
,
isolated_pools AS (
SELECT
TX_HASH,
BLOCK_TIMESTAMP,
sender::STRING AS user
FROM aptos.core.fact_events
JOIN aptos.core.fact_transactions using(TX_HASH)
WHERE EVENT_TYPE IN (
Last run: 9 days ago
...
792
39KB
302s