TOTAL_TRANSACTIONS | TOTAL_USERS | TOTAL_FEES | AVG_TX_FEE | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE_PERCENTAGE | |
---|---|---|---|---|---|---|---|
1 | 3180473 | 10337 | 1.138701145 | 3.580288672e-7 | 3177064 | 3409 | 99.89 |
par_rnSwell 02
Updated 2025-02-01
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
›
⌄
WITH total_transactions AS (
SELECT
COUNT(DISTINCT TX_HASH) AS total_transactions,
COUNT(DISTINCT FROM_ADDRESS) AS total_users,
SUM(TX_FEE) AS total_fees,
AVG(TX_FEE) AS avg_tx_fee,
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,
ROUND(
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = TRUE THEN TX_HASH END) * 100.0
/ NULLIF(COUNT(DISTINCT TX_HASH), 0), 2
) AS success_rate_percentage
FROM swell.core.fact_transactions
),
historical_totals AS (
SELECT
total_transactions,
total_users,
total_fees,
avg_tx_fee,
successful_transactions,
failed_transactions,
success_rate_percentage,
FROM total_transactions
)
SELECT
total_transactions,
total_users,
total_fees,
avg_tx_fee,
successful_transactions,
failed_transactions,
success_rate_percentage,
FROM historical_totals
Last run: 23 days ago
1
63B
1s