hess4. Daily Success Rate
    Updated 2025-05-01
    select block_timestamp::date as date,
    case when (TX_SUCCEEDED = 'TRUE' or TX_SUCCEEDED is null) then 'SUCCESS' else 'FAIL' end as type,
    count(DISTINCT from_address) as address,
    count(DISTINCT tx_hash) as txns
    from mezo.testnet.fact_transactions
    group by 1,2
    order by 1 asc








    Last run: about 1 month ago
    DATE
    TYPE
    ADDRESS
    TXNS
    1
    2025-03-28 00:00:00.000SUCCESS67690
    2
    2025-03-29 00:00:00.000FAIL713
    3
    2025-03-29 00:00:00.000SUCCESS1662456
    4
    2025-03-30 00:00:00.000SUCCESS1663324
    5
    2025-03-30 00:00:00.000FAIL59
    6
    2025-03-31 00:00:00.000FAIL46
    7
    2025-03-31 00:00:00.000SUCCESS1761420
    8
    2025-04-01 00:00:00.000SUCCESS1941924
    9
    2025-04-01 00:00:00.000FAIL724
    10
    2025-04-02 00:00:00.000FAIL1773
    11
    2025-04-02 00:00:00.000SUCCESS3022556
    12
    2025-04-03 00:00:00.000FAIL3286
    13
    2025-04-03 00:00:00.000SUCCESS3273251
    14
    2025-04-04 00:00:00.000SUCCESS5525106
    15
    2025-04-04 00:00:00.000FAIL54118
    16
    2025-04-05 00:00:00.000SUCCESS5394468
    17
    2025-04-05 00:00:00.000FAIL5095
    18
    2025-04-06 00:00:00.000FAIL3678
    19
    2025-04-06 00:00:00.000SUCCESS4514454
    20
    2025-04-07 00:00:00.000SUCCESS5794488
    69
    3KB
    4s