TOTAL_ACTIVE_ADDRESSES | TOTAL_TRANSACTIONS | TOTAL_GAS_FEES | TOTAL_TOKEN_TRANSFERS | NEW_CONTRACTS_DEPLOYED | TOTAL_BLOCKS_PRODUCED | |
|---|---|---|---|---|---|---|
1 | 2601 | 28333 | 599615014.825761 | 54015 | 5527 | 208655 |
kentointeresting-copper
Updated 2025-04-06
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
›
⌄
-- CTEs for each metric
WITH
active_addresses AS (
SELECT COUNT(DISTINCT from_address) AS total_active_addresses
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
),
total_transactions AS (
SELECT COUNT(*) AS total_tx
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
),
total_gas_fees AS (
SELECT SUM(gas_used * gas_price) AS total_gas
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
),
token_transfers AS (
SELECT COUNT(*) AS total_transfers
FROM mezo.testnet.fact_event_logs
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
),
new_contracts AS (
SELECT COUNT(*) AS total_contracts
FROM mezo.testnet.dim_contracts
WHERE created_block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
),
blocks_produced AS (
SELECT COUNT(*) AS total_blocks
FROM mezo.testnet.fact_blocks
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
Last run: about 1 month ago
1
49B
2s