DATE | TRANSACTIONS | ADDRESSES | Average Transaction Per wallet | RECEIVERS | Produced Blocks | |
|---|---|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 690 | 67 | 10.298507 | 140 | 5833 |
2 | 2025-04-22 00:00:00.000 | 21291 | 1554 | 13.700772 | 1384 | 23765 |
3 | 2025-04-21 00:00:00.000 | 18174 | 1493 | 12.172806 | 1344 | 23599 |
4 | 2025-04-23 00:00:00.000 | 24841 | 1303 | 19.064467 | 1743 | 23652 |
5 | 2025-04-26 00:00:00.000 | 33932 | 1529 | 22.192283 | 7157 | 23662 |
6 | 2025-04-04 00:00:00.000 | 5224 | 560 | 9.328571 | 1277 | 23517 |
7 | 2025-03-29 00:00:00.000 | 2469 | 170 | 14.523529 | 276 | 23601 |
8 | 2025-04-07 00:00:00.000 | 4578 | 594 | 7.707071 | 1185 | 23686 |
9 | 2025-04-18 00:00:00.000 | 21526 | 1130 | 19.049558 | 2170 | 23746 |
10 | 2025-04-29 00:00:00.000 | 37433 | 6175 | 6.062024 | 9603 | 23476 |
11 | 2025-04-03 00:00:00.000 | 3337 | 338 | 9.872781 | 876 | 22966 |
12 | 2025-03-30 00:00:00.000 | 3333 | 170 | 19.605882 | 224 | 23539 |
13 | 2025-04-06 00:00:00.000 | 4532 | 460 | 9.852174 | 1371 | 23733 |
14 | 2025-04-14 00:00:00.000 | 12122 | 777 | 15.60103 | 901 | 23709 |
15 | 2025-04-01 00:00:00.000 | 1948 | 196 | 9.938776 | 303 | 23704 |
16 | 2025-05-01 00:00:00.000 | 29829 | 2053 | 14.529469 | 4714 | 16337 |
17 | 2025-04-28 00:00:00.000 | 26897 | 1579 | 17.034199 | 1841 | 23551 |
18 | 2025-04-02 00:00:00.000 | 2629 | 308 | 8.535714 | 336 | 23635 |
19 | 2025-04-20 00:00:00.000 | 19361 | 1075 | 18.010233 | 1054 | 23618 |
20 | 2025-04-12 00:00:00.000 | 11800 | 1006 | 11.729622 | 1005 | 23530 |
hess1. Daily Number of Addresses and Transactions
Updated 2025-05-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with base as (select block_timestamp::date as date,
count(distinct tx_hash) Transactions,
count(distinct from_address) as addresses,
Transactions/addresses as "Average Transaction Per wallet",
count(distinct to_address) as receivers
from mezo.testnet.fact_transactions
group by 1)
,
blocks as ( select count(distinct block_number) as "Produced Blocks",
block_timestamp::date as date
from mezo.testnet.fact_blocks
group by 2)
select a.*,
"Produced Blocks"
from base a join blocks b on a.date = b.date
Last run: about 1 month ago
35
2KB
4s