CHAIN | TOTAL_TRANSACTIONS | TOTAL_WALLETS | |
|---|---|---|---|
1 | Berachain | 195905760 | 62753725 |
2 | Monad | 1442226019 | 513597739 |
adriaparcerisasbera vs monad 1.2
Updated 6 days ago
999
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
monad_launch AS (
SELECT MIN(DATE_TRUNC('hour', BLOCK_TIMESTAMP)) as launch_date
FROM monad.testnet.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2025-02-19'
AND TX_SUCCEEDED = true
),
total_hours as (
SELECT
launch_date,
DATEDIFF('hour', launch_date, CURRENT_TIMESTAMP()) as hours_since_launch
FROM monad_launch
),
launch_dates AS (
SELECT
'Berachain' as chain,
MIN(DATE_TRUNC('hour', BLOCK_TIMESTAMP)) as launch_date
FROM berachain.testnet.fact_transactions
WHERE BLOCK_TIMESTAMP >= '2024-06-10' --'2024-06-07 13:00:00.000'
AND TX_SUCCEEDED = true
UNION ALL
SELECT
'Monad' as chain,
MIN(DATE_TRUNC('hour', BLOCK_TIMESTAMP)) as launch_date
FROM monad.testnet.fact_transactions where BLOCK_TIMESTAMP>='2025-02-19'
and TX_SUCCEEDED = true
),
network_activity AS (
-- Berachain Testnet Metrics with days since launch
SELECT
'Berachain' as chain,
DATE_TRUNC('hour', BLOCK_TIMESTAMP) as activity_date,
l.launch_date,
Last run: 6 days ago
2
65B
236s