TOTAL_SMART_MONEY_ADDRESSES | TOTAL_VOLUME | AVG_TRANSACTIONS_PER_ADDRESS | AVG_ACTIVE_DAYS | MIN_VOLUME | MAX_VOLUME | AVG_VOLUME | |
|---|---|---|---|---|---|---|---|
1 | 28 | 64542.110107126 | 475875.464286 | 148.5 | 1026.55581704 | 7708.95370343 | 2305.075360969 |
superflyyawning-amethyst
Updated 2025-03-18
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
›
⌄
WITH smart_money_addresses AS (
SELECT
from_address,
COUNT(DISTINCT tx_hash) as transaction_count,
SUM(tx_fee) as total_volume,
COUNT(DISTINCT DATE(block_timestamp)) as active_days
FROM
ronin.core.fact_transactions
WHERE
tx_succeeded
GROUP BY
from_address
HAVING
total_volume > 1000
AND active_days > 5
AND transaction_count > 50
)
SELECT
COUNT(DISTINCT from_address) as total_smart_money_addresses,
SUM(total_volume) as total_volume,
AVG(transaction_count) as avg_transactions_per_address,
AVG(active_days) as avg_active_days,
MIN(total_volume) as min_volume,
MAX(total_volume) as max_volume,
AVG(total_volume) as avg_volume
FROM
smart_money_addresses;
Last run: 29 days ago
1
85B
18s