Total Transactions | Total Wallets | Total GAS FEES | AVG fees | Earliest Transaction | Latest Transaction | Transactions Last 4H | Users Last 4H | Transaction Change 4H (%) | User Change 4H (%) | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 40232065 | 1817819 | 431292.857437472 | 0.01053320559 | 2025-02-19 00:00:16.000 | 2025-02-25 16:35:37.000 | 1649793 | 255375 | 4.100692 | 14.048428 |
datavortextotals 2
Updated 2025-02-25
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
›
⌄
WITH last_hours AS (
SELECT
COUNT(DISTINCT tx_hash) AS tx_count,
COUNT(DISTINCT from_address) AS user_count
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= DATEADD('hour', -4, CURRENT_TIMESTAMP)
),
all_time AS (
SELECT
COUNT(DISTINCT tx_hash) AS total_tx,
COUNT(DISTINCT from_address) AS total_users
FROM monad.testnet.fact_transactions
WHERE block_timestamp >= '2025-02-19'
AND tx_succeeded = TRUE
)
SELECT
a.total_tx AS "Total Transactions",
a.total_users AS "Total Wallets",
(SELECT SUM(tx_fee) FROM monad.testnet.fact_transactions WHERE block_timestamp >= '2025-02-19') AS "Total GAS FEES",
(SELECT AVG(tx_fee) FROM monad.testnet.fact_transactions WHERE block_timestamp >= '2025-02-19') AS "AVG fees",
(SELECT MIN(block_timestamp) FROM monad.testnet.fact_transactions WHERE block_timestamp >= '2025-02-19') AS "Earliest Transaction",
(SELECT MAX(block_timestamp) FROM monad.testnet.fact_transactions WHERE block_timestamp >= '2025-02-19') AS "Latest Transaction",
l.tx_count AS "Transactions Last 4H",
l.user_count AS "Users Last 4H",
CASE WHEN a.total_tx > 0 THEN (l.tx_count * 100.0 / a.total_tx) ELSE 0 END AS "Transaction Change 4H (%)",
CASE WHEN a.total_users > 0 THEN (l.user_count * 100.0 / a.total_users) ELSE 0 END AS "User Change 4H (%)"
FROM all_time a
JOIN last_hours l ON 1=1;
Last run: 2 months ago
1
137B
4s