METRIC_CATEGORY | TOTAL_TRANSACTIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE_PERCENTAGE | UNIQUE_SENDERS | UNIQUE_RECEIVERS | TOTAL_VALUE_TRANSFERRED | AVG_VALUE_PER_TX | TOTAL_TX_FEES | AVG_GAS_PRICE | AVG_GAS_USED | PEAK_TRANSACTIONS_PER_HOUR | MIN_TRANSACTIONS_PER_HOUR | AVG_TRANSACTIONS_PER_HOUR | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Overall Metrics | 41054323 | 41016275 | 35783 | 99.91 | 176337 | 170798 | 10495760453.2151 | 255.6552 | 148821.1918 | 50.19 | 71278.34 | 9589390 | 1 | 39437.422671 |
Kruys-CollinsMonad Metrics
Updated 2025-02-20
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 base_metrics AS (
SELECT
COUNT(DISTINCT tx_hash) as total_transactions,
COUNT(DISTINCT CASE WHEN tx_succeeded = true THEN tx_hash END) as successful_transactions,
COUNT(DISTINCT CASE WHEN tx_succeeded = false THEN tx_hash END) as failed_transactions,
COUNT(DISTINCT from_address) as unique_senders,
COUNT(DISTINCT to_address) as unique_receivers,
-- Value metrics
SUM(value) as total_value_transferred,
AVG(value) as avg_value_per_tx,
-- Fee metrics
SUM(tx_fee) as total_tx_fees,
-- Gas metrics
AVG(gas_price) as avg_gas_price,
AVG(gas_used) as avg_gas_used,
-- Success rate calculation components
COUNT(CASE WHEN tx_succeeded = true THEN 1 END)::FLOAT /
NULLIF(COUNT(*), 0) * 100 as success_rate
FROM
monad.testnet.fact_transactions
),
-- Adding date-based metrics
time_metrics AS (
SELECT
DATE_TRUNC('hour', block_timestamp) as hour,
COUNT(*) as txs_per_hour
FROM
monad.testnet.fact_transactions
GROUP BY
hour
ORDER BY
hour
)
Last run: 24 days ago
1
141B
5s