TOTAL_UNIQUE_WALLETS | |
|---|---|
1 | 571803 |
monadmetrics-JFe1_Rlengthy-plum
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
WITH first_transactions AS (
SELECT
from_address,
MIN(block_timestamp) AS first_tx_time
FROM MONAD.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19 15:00:00.000' --
GROUP BY from_address
)
SELECT
COUNT(DISTINCT from_address) AS total_unique_wallets
FROM first_transactions;
Last run: about 1 month ago
1
10B
2s