Total Blocks | AVG Block Time | AVG TPS | MAX TPS | AVG TPB | AVG % of Block Utilization | Block Rate per second | # of Total Wallets | Total Transactions | Total Gas Used | AVG TX Fee | Total ETH Volume | % of Successful Tx | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 17445139 | 2 | 6.877804886256 | 536 | 13.75561 | 14.990195344285 | 0.5 | 1858612 | 239968509 | 78451804534977 | 0.00002525490106 | 9975929.35628863 | 98.1266 |
rezarwzKey Metrics
Updated 5 days ago
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
30
31
32
33
34
35
36
›
⌄
with Transactions_m as (
SELECT
count(DISTINCT from_Address) as "# of Total Wallets",
count(DISTINCT tx_hash) as "Total Transactions",
sum(GAS_USED) as "Total Gas Used",
avg(TX_FEE) as "AVG TX Fee",
sum(value) as "Total ETH Volume",
(
Sum(
CASE
WHEN STATUS = 'SUCCESS' THEN 1
ELSE 0
END
) / (count(DISTINCT tx_hash))
) * 100 AS "% of Successful Tx"
FROM
blast.core.fact_transactions
),
block_m as (
SELECT
count(HASH) as "Total Blocks",
AVG(
TIMEDIFF(SECOND, BLOCK_TIMESTAMP, NEXT_BLOCK_TIMESTAMP)
) AS "AVG Block Time",
AVG(
TX_COUNT / TIMESTAMPDIFF(SECOND, BLOCK_TIMESTAMP, next_block_timestamp)
) AS "AVG TPS",
MAX(
TX_COUNT / TIMESTAMPDIFF(SECOND, BLOCK_TIMESTAMP, next_block_timestamp)
) AS "MAX TPS",
AVG(tx_count) AS "AVG TPB",
AVG((GAS_USED / GAS_LIMIT) * 100) AS "AVG % of Block Utilization",
COUNT(HASH) / (
SELECT
TIMEDIFF(
SECOND,
Last run: 5 days agoAuto-refreshes every 24 hours
1
137B
240s