HOURS | TRANSACTIONS | AVG_WALLET_TXN | WALLETS | AVG_HOURLY_WALLET | Average Transaction Per wallet | RECEIVERS | Produced Blocks | |
|---|---|---|---|---|---|---|---|---|
1 | 121 | 24088781 | 199080.834711 | 1179366 | 9746.826446 | 20.425195 | 1488756 | 685824 |
hesshollow-indigo
Updated 2025-02-25
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
›
⌄
with base 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 monad.testnet.fact_transactions
where block_timestamp::Date >= '2025-02-19' and block_timestamp <= '2025-02-24'
and from_address not in (select distinct to_address
from monad.testnet.fact_traces
where block_timestamp::Date >= '2025-02-19'
and TYPE IN ('CREATE','CREATE2')
and OUTPUT IS NOT NULL
and TX_SUCCEEDED = 'TRUE'
and TRACE_SUCCEEDED = 'TRUE'))
,
blocks as ( select count(distinct block_number) as "Produced Blocks"
from monad.testnet.fact_blocks
where block_timestamp::Date >= '2025-02-19' and block_timestamp <= '2025-02-23')
select a.*,
"Produced Blocks"
from base a , blocks b
Last run: about 2 months ago
1
75B
7s