farid-c9j0VMsuccess rate
    Updated 2022-07-21
    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