DATE | Daily avg tx per block | |
|---|---|---|
1 | 2025-01-10 00:00:00.000 | 0.02483 |
2 | 2025-03-02 00:00:00.000 | 67.444577 |
3 | 2025-03-30 00:00:00.000 | 128.839415 |
4 | 2025-04-21 00:00:00.000 | 110.299674 |
5 | 2025-07-13 00:00:00.000 | 100.410746 |
6 | 2025-07-12 00:00:00.000 | 102.083782 |
7 | 2025-07-10 00:00:00.000 | 75.042065 |
8 | 2025-02-16 00:00:00.000 | 46.017657 |
9 | 2025-01-12 00:00:00.000 | 0.00255 |
10 | 2025-03-22 00:00:00.000 | 157.551986 |
11 | 2025-06-02 00:00:00.000 | 62.226195 |
12 | 2025-06-07 00:00:00.000 | 83.395587 |
13 | 2025-06-12 00:00:00.000 | 75.384472 |
14 | 2025-01-17 00:00:00.000 | 0.029058 |
15 | 2025-01-25 00:00:00.000 | 0.00572 |
16 | 2025-02-24 00:00:00.000 | 57.509124 |
17 | 2025-07-06 00:00:00.000 | 83.922391 |
18 | 2025-01-28 00:00:00.000 | 20.644691 |
19 | 2025-01-24 00:00:00.000 | 171.252165 |
20 | 2025-02-05 00:00:00.000 | 0.126414 |
Mrftibumpy-fuchsia
Updated 17 hours ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with tbl AS
(
SELECT
date_trunc(day, block_timestamp) as date,
count(DISTINCT block_number) as "Daily blocks",
sum(tx_count) as "Daily tx"
from monad.testnet.fact_blocks
GROUP by 1
)
SELECT
date,
"Daily tx"/"Daily blocks" as "Daily avg tx per block"
from tbl
where "Daily tx" is not null
--and date > '2025-02-18 00:00:00.000'
Last run: about 17 hours agoAuto-refreshes every 12 hours
...
191
7KB
8s