LATEST_BLOCK | TOTAL_BLOCKS | FIRST_BLOCK | BLOCK_RANGE | TOTAL_TRANSACTIONS | UNIQUE_SENDERS | UNIQUE_RECEIVERS | SUCCESSFUL_TRANSACTIONS | FAILED_TRANSACTIONS | SUCCESS_RATE | AVG_TRANSACTION_FEE | MAX_TRANSACTION_FEE | MIN_TRANSACTION_FEE | TOTAL_FEES | CONTRACT_CREATION_TXS | TOTAL_EVENTS | ACTIVE_CONTRACTS | TOTAL_CONTRACTS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 4398371 | 963244 | 3435128 | 963243 | 710656 | 78320 | 58170 | 694299 | 14587 | 0.976983 | 0.000001177709719 | 0.0873016 | 0 | 0.8369464782 | 17551 | 2468192 | 6872 | 21883 |
superflycontroversial-white
Updated 2025-05-08
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 block_metrics AS (
SELECT
MAX(block_number) as latest_block,
COUNT(*) as total_blocks,
MIN(block_number) as first_block,
MAX(block_number) - MIN(block_number) as block_range
FROM mezo.testnet.fact_blocks
),
transaction_metrics AS (
SELECT
COUNT(*) as total_transactions,
COUNT(DISTINCT from_address) as unique_senders,
COUNT(DISTINCT to_address) as unique_receivers,
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = 'TRUE' THEN tx_hash END) as successful_transactions,
COUNT(DISTINCT CASE WHEN TX_SUCCEEDED = 'FALSE' THEN tx_hash END) as failed_transactions,
AVG(tx_fee) as avg_transaction_fee,
MAX(tx_fee) as max_transaction_fee,
MIN(tx_fee) as min_transaction_fee,
SUM(tx_fee) as total_fees,
COUNT(DISTINCT CASE WHEN to_address IS NULL THEN tx_hash END) as contract_creation_txs
FROM mezo.testnet.fact_transactions
),
event_metrics AS (
SELECT
COUNT(*) as total_events,
COUNT(DISTINCT contract_address) as active_contracts
FROM mezo.testnet.fact_event_logs
),
contract_metrics AS (
SELECT
COUNT(DISTINCT address) as total_contracts
FROM mezo.testnet.dim_contracts
Last run: 22 days ago
1
142B
3s