HOURS | TRANSACTIONS | AVG_WALLET_TXN | WALLETS | AVG_HOURLY_WALLET | Average Transaction Per wallet | RECEIVERS | Produced Blocks | |
|---|---|---|---|---|---|---|---|---|
1 | 1218 | 118806996 | 97542.689655 | 3710853 | 3046.67734 | 32.016088 | 3692226 | 5341864 |
hesssubtle-crimson
Updated 2025-02-27
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
›
⌄
with base as ( select block_timestamp,
tx_hash,
from_address,
to_address
from monad.testnet.fact_transactions
union
select block_timestamp,
tx_hash,
ORIGIN_FROM_ADDRESS as from_address,
origin_to_address as to_address
from monad.testnet.fact_event_logs)
,
base_i as (select count(distinct date_trunc('hour',block_timestamp)) as hours,
count(distinct tx_hash) Transactions,
Transactions/hours as avg_wallet_txn,
count(distinct from_address) as wallets,
wallets/hours as avg_hourly_wallet,
Transactions/wallets as "Average Transaction Per wallet",
count(distinct to_address) as receivers
from base
)
,
blocks as ( select count(distinct block_number) as "Produced Blocks"
from monad.testnet.fact_blocks
)
select a.*,
"Produced Blocks"
from base_i a , blocks b
Last run: about 2 months ago
1
76B
31s