DAILY | Daily Blocks | Daily Transactions | Average Txns Per Blocks | Cumulative Transactions | DAU | Average Txn Per User | Daily Fees | Average Txn Fee | Median Txn Fee | Max Txn Fee | Min Txn Fee | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-07 00:00:00.000 | 90530 | 6080182 | 67.162068 | 9971160 | 1025716 | 5.927744 | 69575.25320395 | 0.01144295569 | 0.004744324 | 52.5 | 0.00105 |
2 | 2025-03-06 00:00:00.000 | 62100 | 3890978 | 62.656651 | 3890978 | 626014 | 6.215481 | 39689.36289931 | 0.01020035654 | 0.00447928 | 8 | 0.00105 |
oxkimiacolorful-fuchsia
Updated 2025-03-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
-- Daily Transactions, Users and Spent Fees over the Last 24 Hours for Monad Testnet
SELECT
TRUNC(BLOCK_TIMESTAMP, 'day') AS daily,
COUNT(DISTINCT BLOCK_NUMBER) AS "Daily Blocks",
COUNT(DISTINCT tx_hash) AS "Daily Transactions",
"Daily Transactions" / "Daily Blocks" AS "Average Txns Per Blocks",
SUM("Daily Transactions") OVER (ORDER BY daily ASC) AS "Cumulative Transactions",
COUNT(DISTINCT from_address) AS "DAU",
"Daily Transactions" / "DAU" AS "Average Txn Per User",
SUM(tx_fee) AS "Daily Fees",
AVG(tx_fee) AS "Average Txn Fee",
MEDIAN(tx_fee) AS "Median Txn Fee",
MAX(tx_fee) AS "Max Txn Fee",
MIN(tx_fee) AS "Min Txn Fee"
FROM
monad.testnet.fact_transactions
WHERE
BLOCK_TIMESTAMP >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
GROUP BY
1;
Last run: about 1 month ago
2
258B
4s