TOTAL_TRANSACTIONS | TOTAL_SUCCESSFUL_TRANSACTIONS | TOTAL_UNSUCCESSFUL_TRANSACTIONS | TOTAL_DISTINCT_USERS | TOTAL_PRIORITY_FEES_PAID | PERCEMTAGE_UNSUCESSFUL | PERCENTAGE_SUCCESSFUL | TOTAL_FEES_PAID | |
|---|---|---|---|---|---|---|---|---|
1 | 4033615 | 3960885 | 72666 | 328254 | 15166.764089216 | 1.8015 | 98.1969 | 46718.284232564 |
pepperatziMetrics Regarding Monad TestNet Data
Updated 2025-02-20
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
count(distinct tx_hash) as total_transactions,
count(distinct case when tx_succeeded = 'true' then tx_hash end) as total_successful_transactions,
count(distinct case when tx_succeeded = 'false' then tx_hash end) as total_unsuccessful_transactions,
count(distinct from_address) as total_distinct_users,
sum(case when tx_succeeded = 'true' then (coalesce((max_priority_fee_per_gas * gas_used),0) / 1e9) end) as total_priority_fees_paid,
(total_unsuccessful_transactions / total_transactions) * 100 as percemtage_unsucessful,
(total_successful_transactions / total_transactions) * 100 as percentage_successful,
sum(tx_fee) as total_fees_paid
from monad.testnet.fact_transactions
where date_trunc('hour', block_timestamp) >= '2025-02-19 16:00:00'
Last run: about 2 months ago
1
79B
2s