pouya_22Stellar Stats
    Updated 2025-02-21
    with tps as (
    select
    block_timestamp::date as date,
    count(distinct TRANSACTION_HASH) / (24 * 60 * 60) as tps
    from stellar.core.fact_transactions
    where block_timestamp >= '2025-01-01'
    group by 1)

    select
    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,
    (select avg(tps) from tps) as avg_tps
    from stellar.core.fact_transactions
    where block_timestamp >= '2025-01-01'
    Last run: 23 days ago
    TXS
    ACCOUNTS
    AVG_TX_PER_DAY
    SUCCESS_RATE
    AVG_TPS
    1
    2423880655444704661308.94230836.24820353.950335
    1
    55B
    24s