Total Transactions | Successful Transactions | Success Rate (%) | |
|---|---|---|---|
1 | 208686 | 208533 | 99.93 |
datavortexsuccess rate
Updated 2025-05-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
WITH TransactionStats AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_transactions,
COUNT(DISTINCT CASE WHEN receipt_succeeded = TRUE THEN tx_hash END) AS successful_transactions
FROM near.defi.fact_intents
WHERE tx_hash IS NOT NULL
AND receipt_succeeded IS NOT NULL
)
SELECT
total_transactions AS "Total Transactions",
successful_transactions AS "Successful Transactions",
ROUND((successful_transactions::FLOAT / total_transactions) * 100, 2) AS "Success Rate (%)"
FROM TransactionStats;
Last run: 15 days ago
1
23B
2s