UNIQUE_USER_ADDRESSES | |
|---|---|
1 | 535136 |
Kruys-Collinsgreat-yellow
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH contract_addresses AS (
SELECT DISTINCT address FROM monad.testnet.dim_contracts
)
SELECT COUNT(DISTINCT user_address) AS unique_user_addresses
FROM (
SELECT from_address AS user_address FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19'
UNION
SELECT to_address AS user_address FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19'
) tx
LEFT JOIN contract_addresses c ON tx.user_address = c.address
WHERE c.address IS NULL; -- Ensure it's an EOA
Last run: 23 days ago
1
10B
2s