TOTAL_WALLETS_CREATED | AVG_TXS_PER_WALLET | TOTAL_LOW_ACTIVITY_WALLETS | WALLETS_IN_BATCH_HOURS | PERCENTAGE_LOW_ACTIVITY | PERCENTAGE_BATCH_CREATED | |
|---|---|---|---|---|---|---|
1 | 88860581 | 9.18 | 81924668 | 88860581 | 92.19 | 100 |
bobby_daniel7-Wallet Clusters
Updated 2025-04-04
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
›
⌄
WITH wallet_activity AS (
SELECT
signer,
first_tx_date,
num_txs,
num_days_active
FROM solana.core.ez_signers
WHERE first_tx_date >= CURRENT_DATE - 30
),
sybil_summary AS (
SELECT
COUNT(DISTINCT signer) as total_wallets_created,
AVG(num_txs) as overall_avg_txs_per_wallet,
COUNT(DISTINCT CASE WHEN num_txs < 3 THEN signer END) as total_low_activity_wallets,
COUNT(DISTINCT CASE
WHEN DATE_TRUNC('hour', first_tx_date) IN (
SELECT DATE_TRUNC('hour', first_tx_date)
FROM wallet_activity
GROUP BY 1
HAVING COUNT(DISTINCT signer) >= 50
)
THEN signer
END) as wallets_in_batch_hours
FROM wallet_activity
)
SELECT
total_wallets_created,
ROUND(overall_avg_txs_per_wallet, 2) as avg_txs_per_wallet,
total_low_activity_wallets,
wallets_in_batch_hours,
ROUND((total_low_activity_wallets::FLOAT / total_wallets_created * 100), 2) as percentage_low_activity,
ROUND((wallets_in_batch_hours::FLOAT / total_wallets_created * 100), 2) as percentage_batch_created
FROM sybil_summary;
Last run: 2 months ago
1
45B
40s