TOTAL_OPERATIONS | TOTAL_TX_SET_OPERATIONS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | PERIOD_START | PERIOD_END | LEDGERS_PROCESSED | |
|---|---|---|---|---|---|---|---|
1 | 3960707 | 6160244 | 1641291 | 1962794 | 2025-02-18 10:35:09.000 | 2025-02-19 07:59:55.000 | 13182 |
permaryrelieved-teal
Updated 2025-02-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
-- 1. 24h Ledger Statistics
WITH ledger_times AS (
SELECT
DATEDIFF('second', LAG(closed_at) OVER (ORDER BY sequence), closed_at) as time_diff
FROM stellar.core.fact_ledgers
WHERE closed_at >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
)
SELECT
COUNT(DISTINCT FLOOR(total_coins/base_reserve)) as total_accounts,
AVG(time_diff) as avg_ledger_time,
SUM(operation_count) as processed_operations,
SUM(successful_transaction_count) as successful_tx,
SUM(failed_transaction_count) as failed_tx
FROM stellar.core.fact_ledgers
WHERE closed_at >= DATEADD(hour, -24, CURRENT_TIMESTAMP());
-- 2. Latest Ledger Details
SELECT
sequence,
successful_transaction_count,
failed_transaction_count,
operation_count,
DATEDIFF('second', LAG(closed_at) OVER (ORDER BY sequence), closed_at) as closing_time,
protocol_version,
base_fee/10000000.0 as base_operation_fee_xlm,
base_reserve/10000000.0 as base_reserve_xlm
FROM stellar.core.fact_ledgers
WHERE sequence = (
SELECT MAX(sequence)
FROM stellar.core.fact_ledgers
);
-- 3. DEX Statistics (24h)
SELECT
COUNT(*) as trade_count,
SUM(buying_amount) as total_volume
Last run: 27 days ago
1
93B
1s