kaibladeTransactions Volume Stats (Arbitrum)
Updated 2022-07-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
SELECT
(SELECT COUNT(DISTINCT(tx_hash))
FROM arbitrum.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE() - INTERVAL '1 week')
AS total_number_transactions,
(SELECT COUNT(DISTINCT (tx_hash))
FROM arbitrum.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 week' AND status != 'SUCCESS')
AS total_number_failed_transactions,
(SELECT COUNT(DISTINCT (tx_hash))
FROM arbitrum.core.fact_transactions
WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 week' AND status != 'SUCCESS'AND tx_fee > 0)
AS failed_nonzerofees_transactions,
((total_number_failed_transactions/total_number_transactions) * 100)
AS failed_transactions_rate,
((failed_nonzerofees_transactions/total_number_failed_transactions) * 100)
AS failed_nonzerofees_transactions_rate
Run a query to Download Data