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 | 472874 | 439651 | 33223 | 92.97 | 51101 | 8.6 | 0.65 | 0.06 | 9451 | 18.49 |
2 | All transactions | 1091632 | 1058409 | 33223 | 96.96 | 51101 | 20.71 | 0.65 | 0.13 | 9451 | 18.49 |
Kruys-Collinsrepulsive-indigo
Updated 2 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: 2 days ago
2
162B
11s