farid-c9j0VMUntitled Query
Updated 2022-07-21
9
1
2
3
4
5
6
7
8
›
⌄
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
group by 1
Run a query to Download Data