mrwildcatadded-scarlet
    Updated 2025-02-18
    select
    date_trunc('day', block_timestamp) as date,
    count(transaction_hash) as tx_count,
    transaction_result_code
    from
    stellar.core.fact_transactions
    group by 1,3
    order by 1 desc
    Last run: 27 days ago
    DATE
    TX_COUNT
    TRANSACTION_RESULT_CODE
    1
    2025-02-18 00:00:00.000132416TransactionResultCodeTxFailed
    2
    2025-02-18 00:00:00.000256TransactionResultCodeTxFeeBumpInnerFailed
    3
    2025-02-18 00:00:00.0006502TransactionResultCodeTxFeeBumpInnerSuccess
    4
    2025-02-18 00:00:00.00096730TransactionResultCodeTxSuccess
    5
    2025-02-17 00:00:00.0001738764TransactionResultCodeTxFailed
    6
    2025-02-17 00:00:00.0007562TransactionResultCodeTxFeeBumpInnerFailed
    7
    2025-02-17 00:00:00.000100662TransactionResultCodeTxFeeBumpInnerSuccess
    8
    2025-02-17 00:00:00.0001657925TransactionResultCodeTxSuccess
    9
    2025-02-16 00:00:00.00091349TransactionResultCodeTxFeeBumpInnerSuccess
    10
    2025-02-16 00:00:00.0001875381TransactionResultCodeTxFailed
    11
    2025-02-16 00:00:00.0008691TransactionResultCodeTxFeeBumpInnerFailed
    12
    2025-02-16 00:00:00.0001614503TransactionResultCodeTxSuccess
    13
    2025-02-15 00:00:00.000102087TransactionResultCodeTxFeeBumpInnerSuccess
    14
    2025-02-15 00:00:00.0003924TransactionResultCodeTxFeeBumpInnerFailed
    15
    2025-02-15 00:00:00.0001680793TransactionResultCodeTxSuccess
    16
    2025-02-15 00:00:00.0001849430TransactionResultCodeTxFailed
    17
    2025-02-14 00:00:00.0001769535TransactionResultCodeTxSuccess
    18
    2025-02-14 00:00:00.0003873TransactionResultCodeTxFeeBumpInnerFailed
    19
    2025-02-14 00:00:00.0002486480TransactionResultCodeTxFailed
    20
    2025-02-14 00:00:00.000130460TransactionResultCodeTxFeeBumpInnerSuccess
    ...
    1704
    122KB
    70s