Sbhn_NPyawning-amaranth
    Updated 2025-02-02
    select
    count(DISTINCT tx_hash) as txs,
    count(DISTINCT case when tx_succeeded then tx_hash end) as success,
    count(DISTINCT case when tx_succeeded='false' then tx_hash end) as failed,
    (success/txs)*100 as success_rate
    from berachain.testnet.fact_transactions
    where block_timestamp::date >= '2024-06-01'

    Last run: 10 days ago
    TXS
    SUCCESS
    FAILED
    SUCCESS_RATE
    1
    6666062446233409644326528093.5096
    1
    40B
    716s