Transactions | Users | Total Fees Spent | Total Days | Total Successful Transactions | Total Unsuccessful Transactions | Transaction Success Rate | |
|---|---|---|---|---|---|---|---|
1 | 6353792 | 15487 | 1.742093181 | 135 | 6341369 | 12423 | 99.804479 |
i_danoverview
Updated 2025-04-10
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
COUNT(tx_hash) AS "Transactions"
, COUNT(DISTINCT from_address) AS "Users"
, SUM(tx_fee) AS "Total Fees Spent"
, COUNT(DISTINCT date_trunc(day, block_timestamp)) AS "Total Days"
, COUNT(CASE WHEN tx_succeeded THEN tx_hash END) AS "Total Successful Transactions"
, COUNT(CASE WHEN NOT tx_succeeded THEN tx_hash END) AS "Total Unsuccessful Transactions"
, SUM(CASE WHEN tx_succeeded THEN 1 ELSE 0 END) * 100.0 / NULLIF(COUNT(tx_hash), 0) AS "Transaction Success Rate"
FROM swell.core.fact_transactions
Last run: 14 days ago
1
57B
3s