pouya_22Stellar Stats Overtime
    Updated 2025-02-21
    select
    block_timestamp::date as date,
    count(distinct TRANSACTION_HASH) / (24 * 60 * 60) as tps,
    count(distinct transaction_hash) as txs,
    count(distinct account) as accounts,
    txs / count(distinct block_timestamp::date) as avg_tx_per_day,
    (sum(CASE WHEN successful THEN 1 ELSE 0 end) * 100) / txs as success_rate
    from stellar.core.fact_transactions
    where block_timestamp >= '2025-01-01'
    group by 1
    Last run: 23 days ago
    DATE
    TPS
    TXS
    ACCOUNTS
    AVG_TX_PER_DAY
    SUCCESS_RATE
    1
    2025-01-14 00:00:00.00043.160671372908270787372908237.969774
    2
    2025-02-18 00:00:00.00046.100451398307979871398307944.744807
    3
    2025-01-15 00:00:00.00055.117778476217676246476217635.912595
    4
    2025-01-24 00:00:00.00055.556817480010972449480010932.92969
    5
    2025-01-08 00:00:00.00057.154954493818874687493818833.846342
    6
    2025-01-18 00:00:00.00064.076782553623471435553623428.848112
    7
    2025-01-04 00:00:00.00056.174444485347296156485347233.46188
    8
    2025-02-01 00:00:00.00049.243681425465475000425465438.208653
    9
    2025-01-17 00:00:00.00054.78147473311973958473311932.840966
    10
    2025-02-03 00:00:00.00077.147697666556179111666556131.143575
    11
    2025-02-21 00:00:00.00029.852535257925968985257925943.32252
    12
    2025-01-29 00:00:00.00054.52206471070671867471070635.707429
    13
    2025-02-15 00:00:00.00042.086042363623473420363623449.030948
    14
    2025-01-05 00:00:00.00059.4771885138829122686513882932.999678
    15
    2025-01-01 00:00:00.00078.393507677319990555677319924.245323
    16
    2025-02-20 00:00:00.00051.274352443010491641443010441.146822
    17
    2025-02-17 00:00:00.00040.566123350491376001350491350.174912
    18
    2025-01-23 00:00:00.00055.313056477904876164477904834.203528
    19
    2025-01-06 00:00:00.00051.4703014447034111374444703440.131737
    20
    2025-02-14 00:00:00.00050.814225439034983596439034943.276628
    52
    4KB
    11s