DATE | USER_COUNT | TX_COUNT | SECONDS_PER_DAY | TPS | CUM_TX_COUNT | |
---|---|---|---|---|---|---|
1 | 2025-01-01 00:00:00.000 | 408001 | 150855716 | 86400 | 1746.015231 | 150855716 |
2 | 2025-02-01 00:00:00.000 | 232930 | 67500869 | 86400 | 781.260058 | 218356585 |
elsinaDaily activity
Updated 2025-02-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
SELECT
date_trunc('month', block_timestamp) as date,
count(DISTINCT account) as user_count,
count(DISTINCT transaction_hash) as tx_count,
24 * 60 * 60 AS seconds_per_day,
count(DISTINCT transaction_hash) / seconds_per_day as TPS,
sum(tx_count) over (order by date) as cum_tx_count
from
stellar.core.fact_transactions
where
date >= '2025-01-01'
group by
date
order by
date asc
Last run: about 1 month ago
2
145B
41s