HOUR | NEW_WALLETS | |
|---|---|---|
1 | 2025-02-22 13:00:00.000 | 5724 |
2 | 2025-02-22 12:00:00.000 | 9239 |
3 | 2025-02-22 11:00:00.000 | 9027 |
4 | 2025-02-22 10:00:00.000 | 9186 |
5 | 2025-02-22 09:00:00.000 | 7645 |
6 | 2025-02-22 08:00:00.000 | 10514 |
7 | 2025-02-22 07:00:00.000 | 10540 |
8 | 2025-02-22 06:00:00.000 | 9876 |
9 | 2025-02-22 05:00:00.000 | 12818 |
10 | 2025-02-22 04:00:00.000 | 14369 |
11 | 2025-02-22 03:00:00.000 | 13199 |
12 | 2025-02-22 02:00:00.000 | 11016 |
13 | 2025-02-22 01:00:00.000 | 6534 |
14 | 2025-02-22 00:00:00.000 | 6359 |
15 | 2025-02-21 23:00:00.000 | 6632 |
16 | 2025-02-21 22:00:00.000 | 8840 |
17 | 2025-02-21 21:00:00.000 | 7115 |
18 | 2025-02-21 20:00:00.000 | 8689 |
19 | 2025-02-21 19:00:00.000 | 9069 |
20 | 2025-02-21 18:00:00.000 | 8393 |
datavortexHourly New Wallets
Updated 2025-02-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
WITH first_tx AS (
SELECT
from_address,
MIN(block_timestamp) AS first_seen
FROM
monad.testnet.fact_transactions
where tx_succeeded = TRUE
GROUP BY
from_address
)
SELECT
DATE_TRUNC('hour', first_seen) AS hour,
COUNT(DISTINCT from_address) AS new_wallets
FROM
first_tx
WHERE
first_seen >= '2025-02-19'
GROUP BY
1
ORDER BY
hour DESC;
Last run: 2 months ago
86
3KB
2s