TXS | USERS | FEE | AVG_FEES | FEE_USD | AVG_FEES_USD | SUCCESS_RATE | SUCCEEDED | FAILED | MIN_TIME | MAX_TIME | DAYS | AVG_TXS | AVG_USERS | AVG_FEE | AVG_FEE_PER_TX | AVG_FEE_USD | AVG_FEE_PER_TX_USD | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 269279554 | 578207 | 159360.341811 | 0.000591802606 | 1963.185771308 | 0.0001679370624 | 37.118 | 99950186 | 169329368 | 2025-01-01 00:00:02.000 | 2025-02-28 12:09:58.000 | 59 | 4564060.237288 | 9800.118644 | 2701.022742559322 | 0.000591802606 | 33.274335107 | 0.00000729051182 |
mamad-5XN3k3Stellar 2
Updated 2025-02-28
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
›
⌄
with pricet as (
select
HOUR::date as pdate,
avg(PRICE) as avg_price
from crosschain.price.ez_prices_hourly
where symbol = 'XLM'
and hour::date >= '2025-01-01'
group by 1
)
select
--date_trunc('hour', block_timestamp) as date,
count(DISTINCT TRANSACTION_HASH) as txs,
count(DISTINCT ACCOUNT) as users,
sum(FEE_CHARGED)/1e7 as fee,
avg(FEE_CHARGED)/1e7 as avg_fees,
sum(FEE_CHARGED * avg_price)/1e7 as fee_usd,
avg(FEE_CHARGED * avg_price)/1e7 as avg_fees_usd,
round(count(case when SUCCESSFUL = 'TRUE' then TRANSACTION_HASH end)*100/count(DISTINCT TRANSACTION_HASH),3) as success_rate,
count(case when SUCCESSFUL = 'TRUE' then TRANSACTION_HASH end) as succeeded,
count(case when SUCCESSFUL != 'TRUE' then TRANSACTION_HASH end) as failed,
min(BLOCK_TIMESTAMP) as min_time,
max(BLOCK_TIMESTAMP) as max_time,
count(distinct BLOCK_TIMESTAMP::date) as days,
count(DISTINCT TRANSACTION_HASH)/count(distinct BLOCK_TIMESTAMP::date) as avg_txs,
count(DISTINCT ACCOUNT)/count(distinct BLOCK_TIMESTAMP::date) as avg_users,
(sum(FEE_CHARGED)/1e7)/count(distinct BLOCK_TIMESTAMP::date) as avg_fee,
(sum(FEE_CHARGED)/1e7)/count(DISTINCT TRANSACTION_HASH) as avg_fee_per_tx,
(sum(FEE_CHARGED * avg_price)/1e7)/count(distinct BLOCK_TIMESTAMP::date) as avg_fee_usd,
(sum(FEE_CHARGED * avg_price)/1e7)/count(DISTINCT TRANSACTION_HASH) as avg_fee_per_tx_usd
from stellar.core.fact_transactions
left join pricet on date_trunc('hour', block_timestamp) = pdate
where block_timestamp::date >= '2025-01-01'
--where transaction_hash = '4c269995eefc7185d40100a8d990ee42ef30e6588ddfef15a58182e6bc2f9322'
--where block_timestamp >= '2024-12-17 11:00:00.000'
--group by 1
Last run: 16 days ago
1
251B
19s