Sbhn_NPassociated-yellow
    Updated 2025-02-18
    with price as (
    select hour::date as datee,
    avg(price) as usdprice
    from stellar.price.ez_prices_hourly
    where symbol = 'XLM'
    group by 1
    )

    select count(DISTINCT transaction_hash) as txs,
    count(DISTINCT account) as users,
    sum(operation_count) as ops,
    count(DISTINCT LEDGER_sequence) as ledgers,
    count(DISTINCT case when successful then transaction_hash end) as successful_txs,
    count(DISTINCT case when successful='FALSE' then transaction_hash end) as failed_txs,
    sum(fee_charged/1e7) as xlm_fees,
    sum((fee_charged/1e7)*usdprice) as usd_fees,
    (successful_txs/txs)*100 as success_rate
    from stellar.core.fact_transactions
    join price on block_timestamp::date=datee
    Last run: 29 days ago
    TXS
    USERS
    OPS
    LEDGERS
    SUCCESSFUL_TXS
    FAILED_TXS
    XLM_FEES
    USD_FEES
    SUCCESS_RATE
    1
    19049245642251677429181081560754667597469831145177581915891.598658181737.09801340439.8833
    1
    101B
    469s