TOTAL_MINING_TRANSACTIONS | TOTAL_MINERS | AVG_TRANSACTIONS_PER_HOUR | AVG_TRANSACTIONS_PER_MINUTE | AVG_TRANSACTIONS_PER_DAY | AVG_TRANSACTIONS_PER_MINER | START_DATE | END_DATE | ACTIVE_DAYS | DAILY_TRANSACTION_AVERAGE | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 101813889 | 25736 | 65475 | 1092 | 1542635 | 3956 | 2025-04-11 19:38:29.000 | 2025-06-15 13:39:50.000 | 66 | 2447776.14 |
superflyconventional-fuchsia
Updated 2025-06-15
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
›
⌄
WITH daily_stats AS (
SELECT
date_trunc('day', block_timestamp) as day,
COUNT(DISTINCT tx_id) as daily_tx_count
FROM eclipse.core.fact_events
WHERE
PROGRAM_ID = 'F1ULBrY2Tjsmb1L4Wt4vX6UtiWRikLoRFWooSpxMM6nR'
AND SUCCEEDED = 'TRUE'
GROUP BY day
)
SELECT
COUNT(DISTINCT tx_id) as total_mining_transactions,
COUNT(DISTINCT SIGNERS[0]) as total_miners,
ROUND(COUNT(DISTINCT tx_id) / COUNT(DISTINCT date_trunc('hour', block_timestamp))) as avg_transactions_per_hour,
ROUND(COUNT(DISTINCT tx_id) / COUNT(DISTINCT date_trunc('minute', block_timestamp))) as avg_transactions_per_minute,
ROUND(COUNT(DISTINCT tx_id) / COUNT(DISTINCT date_trunc('day', block_timestamp))) as avg_transactions_per_day,
ROUND(COUNT(DISTINCT tx_id) / COUNT(DISTINCT SIGNERS[0])) as avg_transactions_per_miner,
MIN(block_timestamp) as start_date,
MAX(block_timestamp) as end_date,
COUNT(DISTINCT date_trunc('day', block_timestamp)) as active_days,
ROUND(AVG(daily_tx_count), 2) as daily_transaction_average
FROM eclipse.core.fact_events
LEFT JOIN daily_stats ON date_trunc('day', block_timestamp) = daily_stats.day
WHERE
PROGRAM_ID = 'F1ULBrY2Tjsmb1L4Wt4vX6UtiWRikLoRFWooSpxMM6nR'
AND SUCCEEDED = 'TRUE'
Last run: 15 days ago
1
109B
134s