TOTAL_ACTIVE_WALLETS | TOTAL_NEW_WALLETS_LAST_7D | |
|---|---|---|
1 | 3711 | 196 |
feyikemiWallets totals
Updated 2025-03-26
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
›
⌄
WITH transfers AS (
SELECT
FROM_ADDRESS,
BLOCK_TIMESTAMP
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND BLOCK_TIMESTAMP :: Date >= '2025-02-22'
),
first_seen AS (
SELECT
FROM_ADDRESS,
MIN(BLOCK_TIMESTAMP) AS first_tx
FROM ronin.core.ez_token_transfers
WHERE CONTRACT_ADDRESS = '0xf988f63bf26c3ed3fbf39922149e3e7b1e5c27cb'
AND BLOCK_TIMESTAMP :: Date >= '2025-02-22'
GROUP BY FROM_ADDRESS
)
SELECT
COUNT(DISTINCT t.FROM_ADDRESS) AS total_active_wallets,
COUNT(DISTINCT CASE
WHEN f.first_tx >= CURRENT_DATE - INTERVAL '7 days' THEN t.FROM_ADDRESS
END) AS total_new_wallets_last_7d
FROM transfers t
JOIN first_seen f ON t.FROM_ADDRESS = f.FROM_ADDRESS
Last run: 2 months ago
1
12B
1s