Tx_Type | Total Transactions | Successful Transactions | Failed Transactions | Transaction Success Rate (%) | Unique Users | Average Successful Transactions per User | Average Failed Transactions per User | Successful Transactions per Second | Users with Failed Transactions | Percentage of Users Experiencing Failures (%) | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | User transactions | 286302 | 276663 | 9639 | 96.63 | 31726 | 8.72 | 0.3 | 0.04 | 676 | 2.13 |
2 | All transactions | 658281 | 648642 | 9639 | 98.54 | 31726 | 20.44 | 0.3 | 0.1 | 676 | 2.13 |
Kruys-Collinsrepulsive-indigo
Updated 9 days ago
999
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 all_transactions_user AS (
SELECT
tx_hash,
sender,
success,
block_timestamp,
'user_transaction' AS tx_type
FROM movement.core.fact_transactions
WHERE tx_type = 'user_transaction'
AND block_timestamp > '2025-01-01'
),
all_transactions_all AS (
SELECT
tx_hash,
sender,
success,
block_timestamp,
tx_type
FROM movement.core.fact_transactions
WHERE block_timestamp > '2025-01-01'
),
active_users_user AS (
SELECT
sender AS user_address,
COUNT(DISTINCT tx_hash) AS total_transaction_count,
COUNT(DISTINCT CASE WHEN success = 'TRUE' THEN tx_hash ELSE NULL END) AS successful_transaction_count,
COUNT(DISTINCT CASE WHEN success = 'FALSE' THEN tx_hash ELSE NULL END) AS failed_transaction_count
FROM all_transactions_user
GROUP BY sender
),
active_users_all AS (
SELECT
sender AS user_address,
COUNT(DISTINCT tx_hash) AS total_transaction_count,
COUNT(DISTINCT CASE WHEN success = 'TRUE' THEN tx_hash ELSE NULL END) AS successful_transaction_count,
COUNT(DISTINCT CASE WHEN success = 'FALSE' THEN tx_hash ELSE NULL END) AS failed_transaction_count
Last run: 9 days ago
2
152B
4s