TXS | USERS | OPS | LEDGERS | SUCCESSFUL_TXS | FAILED_TXS | XLM_FEES | USD_FEES | SUCCESS_RATE | |
---|---|---|---|---|---|---|---|---|---|
1 | 1904924564 | 2251677 | 4291810815 | 6075466 | 759746983 | 1145177581 | 915891.598658 | 181737.098013404 | 39.8833 |
Sbhn_NPassociated-yellow
Updated 2025-02-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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
1
101B
469s