farid-c9j0VMsuccess rate
Updated 2022-07-21
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT block_timestamp::date as date,
COUNT (DISTINCT CASE WHEN substr(tx_receipt[0]:"outcome":"status",3,7)
like 'Success' THEN TXN_HASH end) as n_success,
COUNT (DISTINCT CASE WHEN substr(tx_receipt[0]:"outcome":"status",3,7)
like 'Failure' THEN TXN_HASH end) as n_fail,
n_success/(n_success+n_fail)*100 as success_rate
FROM flipside_prod_db.mdao_near.transactions
where date>='2022-01-01'
group by 1
Run a query to Download Data