DATE | Daily avg tx per block | |
|---|---|---|
1 | 2024-07-25 00:00:00.000 | 55.787519 |
2 | 2024-08-10 00:00:00.000 | 44.67028 |
3 | 2024-10-05 00:00:00.000 | 93.20361 |
4 | 2024-10-23 00:00:00.000 | 33.660913 |
5 | 2024-08-04 00:00:00.000 | 47.667599 |
6 | 2024-10-29 00:00:00.000 | 40.351564 |
7 | 2024-11-18 00:00:00.000 | 38.808482 |
8 | 2024-11-25 00:00:00.000 | 30.554231 |
9 | 2024-12-07 00:00:00.000 | 31.186715 |
10 | 2024-12-10 00:00:00.000 | 40.629247 |
11 | 2024-12-05 00:00:00.000 | 33.156518 |
12 | 2025-01-05 00:00:00.000 | 145.530193 |
13 | 2024-11-08 00:00:00.000 | 46.10585 |
14 | 2024-11-26 00:00:00.000 | 32.020626 |
15 | 2025-01-23 00:00:00.000 | 131.893281 |
16 | 2025-02-04 00:00:00.000 | 77.618872 |
17 | 2025-01-21 00:00:00.000 | 108.258823 |
18 | 2024-06-08 00:00:00.000 | 209.397284 |
19 | 2024-06-13 00:00:00.000 | 11.953594 |
20 | 2024-07-21 00:00:00.000 | 68.236912 |
Mrfti2024-07-25 12:47 AM
Updated 2025-03-05
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 berachain.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
--GROUP by 1,2
Last run: about 1 month agoAuto-refreshes every 12 hours
...
246
9KB
1s