Lordkingarbit 1
Updated 2022-08-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH n_ as ( -- near
SELECT
'arbitrum' as chain
, date_trunc('day', block_timestamp) as date
, count(*) as tx_count
, count(CASE WHEN STATUS ='SUCCESS' THEN 1 END) as fail_tx_count
FROM arbitrum.core.fact_transactions
WHERE block_timestamp::date >= CURRENT_DATE-60
AND block_timestamp::date < CURRENT_DATE
GROUP BY date
)
SELECT
sum(tx_count-fail_tx_count)/(60*1440) as tx_per_min
, sum(fail_tx_count)/sum(tx_count)*100 as fail_rate
FROM n_
Run a query to Download Data