TOTAL_TRANSACTIONS | UNIQUE_SENDERS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE_PERCENTAGE | TOTAL_TX_FEE | AVERAGE_FEES | |
|---|---|---|---|---|---|---|---|
1 | 12697585 | 505306 | 12365127 | 332458 | 97.38 | 137718.851501199 | 0.01084606652 |
par_rnMantle 01
Updated 2025-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions,
COUNT(DISTINCT from_address) AS unique_senders,
COUNT(DISTINCT CASE WHEN tx_succeeded THEN tx_hash END) AS successful_transactions,
COUNT(DISTINCT CASE WHEN NOT tx_succeeded THEN tx_hash END) AS failed_transactions,
ROUND(
COUNT(DISTINCT CASE WHEN tx_succeeded THEN tx_hash END) * 100.0 /
NULLIF(COUNT(DISTINCT tx_hash), 0),
2
) AS success_rate_percentage,
SUM(tx_fee) AS total_tx_fee,
AVG(tx_fee) AS average_fees
FROM
mantle.core.fact_transactions
WHERE
block_timestamp >= DATEADD(DAY, -30, CURRENT_DATE)
Last run: 30 days ago
1
72B
3s