WALLET_ADDRESS | TOTAL_TRANSACTIONS | TOTAL_CONTRACTS_INTERACTED | TOTAL_FEES_ETH | ACTIVE_DAYS | ACTIVE_WEEKS | ACTIVE_MONTHS | MOST_POPULAR_CONTRACT | MOST_POPULAR_CONTRACT_LABEL | MOST_POPULAR_CONTRACT_TXS | TRANSACTION_RANK | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0xe5891c130a3bd9694f772b9725703119c6dffead | 163 | 32 | 3.350882558e-18 | 2 | 2 | 1 | 0x88b96af200c8a9c35442c8ac6cd3d22695aae4f0 | Ambient Finance | 37 | 3465 |
AUSLANDERONEGetting Started
Updated 2025-02-25
999
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) / 1e18 AS total_fees_eth, -- Переводим комиссии в ETH
COUNT(DISTINCT DATE(t.block_timestamp)) AS active_days,
COUNT(DISTINCT DATE_TRUNC('week', t.block_timestamp)) AS active_weeks,
COUNT(DISTINCT DATE_TRUNC('month', t.block_timestamp)) AS active_months
FROM monad.testnet.fact_transactions t
LEFT JOIN contracts c
ON t.to_address = c.contract
WHERE t.block_timestamp >= CURRENT_TIMESTAMP() - INTERVAL '30 days'
AND t.from_address IN ('0x1e1bD10bc1A59c647A1a6377FF063148B6f9aAaF', '0xa340b9d2819cc346d07ac7b198ff25218fa9f9b1', '0xe5891c130a3bd9694f772b9725703119c6dffead') -- Вставьте список кошельков
GROUP BY 1
),
popular_contracts AS (
SELECT
from_address AS wallet_address,
to_address AS contract_address,
COUNT(tx_hash) AS tx_count,
Last run: 2 months ago
1
148B
19s