chain launch date | first block and transaction time | first block number | no. of blocks created on first day | no. of transactions on first day | first day avg transaction fee | first transaction hash | first user to transact on Mezo chain (from address) | first recipient (to address) | value transacted | succeeded? | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-28 00:00:00.000 | 2025-03-28 18:07:21.000 | 3435171 | 590 | 690 | 0 | 0xf2cf4c7c2d2f26cb8c856a92f00ee0930d7c4846dca751cb7880df98de5444e9 | 0x34d3d2ef5967161f6766681d1106729bc19311db | 0x20faea18b6a1d0fcdbccfffe3d164314744baf30 | 0.0001221909 | true |
defi__joshMezo Chain Launch Date and First Activity Metrics
Updated 7 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 daily_stats AS (
SELECT
DATE_TRUNC('day', block_timestamp) as date,
MIN(block_timestamp) as first_block_time,
MIN(block_number) as first_block_number,
COUNT(DISTINCT block_number) as blocks_created,
COUNT(DISTINCT tx_hash) as total_transactions,
AVG(gas_used) as avg_gas_used,
AVG(tx_fee) as avg_tx_fee
FROM mezo.testnet.fact_transactions
GROUP BY 1
ORDER BY 1
),
chain_stats AS (
SELECT
MIN(date) as "chain launch date",
first_block_time as "first block and transaction time",
first_block_number as "first block number",
blocks_created as "no. of blocks created on first day",
total_transactions as "no. of transactions on first day",
ROUND(avg_tx_fee, 6) as "first day avg transaction fee"
FROM daily_stats
WHERE date = (SELECT MIN(date) FROM daily_stats)
GROUP BY 2, first_block_number, blocks_created, total_transactions, avg_tx_fee
)
SELECT
c.*,
t.tx_hash as "first transaction hash",
t.from_address as "first user to transact on Mezo chain (from address)",
t.to_address as "first recipient (to address)",
t.value as "value transacted",
t.tx_succeeded as "succeeded?"
FROM chain_stats c
CROSS JOIN mezo.testnet.fact_transactions t
Last run: 7 days ago
1
250B
1s