DAY | DAILY_ACTIVE_WALLETS | |
|---|---|---|
1 | 2025-01-02 00:00:00.000 | 231 |
2 | 2025-01-03 00:00:00.000 | 282 |
3 | 2025-01-04 00:00:00.000 | 195 |
4 | 2025-01-05 00:00:00.000 | 257 |
5 | 2025-01-06 00:00:00.000 | 208 |
6 | 2025-01-07 00:00:00.000 | 248 |
7 | 2025-01-08 00:00:00.000 | 178 |
8 | 2025-01-09 00:00:00.000 | 188 |
9 | 2025-01-10 00:00:00.000 | 189 |
10 | 2025-01-11 00:00:00.000 | 159 |
11 | 2025-01-12 00:00:00.000 | 166 |
12 | 2025-01-13 00:00:00.000 | 162 |
13 | 2025-01-14 00:00:00.000 | 178 |
14 | 2025-01-15 00:00:00.000 | 168 |
15 | 2025-01-16 00:00:00.000 | 153 |
16 | 2025-01-17 00:00:00.000 | 192 |
17 | 2025-01-18 00:00:00.000 | 160 |
18 | 2025-01-19 00:00:00.000 | 125 |
19 | 2025-01-20 00:00:00.000 | 106 |
20 | 2025-01-21 00:00:00.000 | 120 |
victor-sanzcapdetEvolution of the Number of Active Wallets
Updated 2025-02-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT
DATE(block_timestamp) AS day,
COUNT(DISTINCT wallet_address) AS daily_active_wallets
FROM (
SELECT seller_address AS wallet_address, block_timestamp
FROM aptos.nft.ez_nft_sales
WHERE block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
AND seller_address IS NOT NULL
UNION
SELECT buyer_address AS wallet_address, block_timestamp
FROM aptos.nft.ez_nft_sales
WHERE block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
AND buyer_address IS NOT NULL
) AS combined_wallets
GROUP BY day
ORDER BY day;
Last run: 3 months ago
32
1023B
3s