TOTAL_UNIQUE_WALLETS_LAST_24H | |
|---|---|
1 | 428705 |
monadmetrics-JFe1_Rzealous-green
Updated 2025-02-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
WITH first_transactions_24h AS (
SELECT
from_address,
MIN(block_timestamp) AS first_tx_time
FROM MONAD.testnet.fact_transactions
WHERE block_timestamp >= DATEADD('day', -1, CURRENT_TIMESTAMP) -- ۲۴ ساعت اخیر
GROUP BY from_address
)
SELECT
COUNT(DISTINCT from_address) AS total_unique_wallets_last_24h
FROM first_transactions_24h;
Last run: about 1 month ago
1
10B
2s