WALLET_ADDRESS | TOTAL_TRANSACTIONS | TOTAL_CONTRACTS_INTERACTED | TOTAL_FEES | ACTIVE_DAYS | MOST_POPULAR_CONTRACT | MOST_POPULAR_CONTRACT_LABEL | MOST_POPULAR_CONTRACT_TXS | TRANSACTION_RANK | |
|---|---|---|---|---|---|---|---|---|---|
1 | 0x66ec04035f2f14bbbfe744a8a56ca02fd21582ff | 366 | 46 | 3.529649315 | 30 | 0xc816865f172d640d93712c68a7e1f83f3fa63235 | Unknown | 135 | 10303 |
dannyamahNew Wallet Stats
Updated 5 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH contracts AS (
SELECT
MIN(tr.block_timestamp) AS create_timestamp,
tr.tx_hash,
tr.to_address AS contract
FROM monad.testnet.fact_traces tr
JOIN monad.testnet.fact_transactions t ON tr.tx_hash = t.tx_hash
WHERE tr.type ILIKE 'create%'
AND tr.tx_succeeded = TRUE
AND tr.trace_succeeded = TRUE
AND tr.to_address IS NOT NULL
GROUP BY 2, 3
),
user_metrics AS (
SELECT
t.from_address AS wallet_address,
COUNT(*) AS total_transactions,
COUNT(DISTINCT c.contract) AS unique_contracts,
SUM(tx_fee) AS total_fees,
COUNT(DISTINCT DATE(t.block_timestamp)) AS active_days
FROM monad.testnet.fact_transactions t
LEFT JOIN contracts c
ON t.to_address = c.contract
WHERE t.block_timestamp::date >= '2025-02-19'
GROUP BY 1
),
popular_contracts AS (
SELECT
from_address AS wallet_address,
to_address AS contract_address,
COUNT(tx_hash) AS tx_count,
ROW_NUMBER() OVER (PARTITION BY from_address ORDER BY COUNT(tx_hash) DESC) AS rank
FROM monad.testnet.fact_transactions
WHERE tx_succeeded = TRUE AND to_address IS NOT NULL
Last run: about 3 hours ago
1
135B
145s