DAYS | TRANSACTIONS | AVG_DAILY_TXN | ADDRESSES | AVG_HOURLY_WALLET | Average Transaction Per wallet | RECEIVERS | Produced Blocks | |
|---|---|---|---|---|---|---|---|---|
1 | 35 | 522446 | 14927.028571 | 32276 | 922.171429 | 16.186826 | 49826 | 799392 |
hess0. Total Transactions and Address
Updated 2025-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with base as (select count(distinct date_trunc('day',block_timestamp)) as days,
count(distinct tx_hash) Transactions,
Transactions/days as avg_daily_txn,
count(distinct from_address) as addresses,
addresses/days as avg_hourly_wallet,
Transactions/addresses as "Average Transaction Per wallet",
count(distinct to_address) as receivers
from mezo.testnet.fact_transactions
)
,
blocks as ( select count(distinct block_number) as "Produced Blocks"
from mezo.testnet.fact_blocks
)
select a.*,
"Produced Blocks"
from base a , blocks b
Last run: 27 days ago
1
66B
3s