Eman-RazCurrent Success Rate
    Updated 2025-02-03
    with tab1 as (select count(distinct tx_hash) as succeeded_txns
    from aurora.core.fact_transactions
    where block_timestamp::date = current_date - 1
    and status='SUCCESS'
    and status<>'Series 3'),

    tab2 as (select count(distinct tx_hash) as total_txns
    from aurora.core.fact_transactions
    where block_timestamp::date = current_date - 1
    and status<>'Series 3')

    select (succeeded_txns/total_txns)*100 "Success Rate"
    from tab1 , tab2
    Last run: 3 months ago
    Success Rate
    1
    99.1373
    1
    11B
    2s