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-06 00:00:00.000 | 55588 | 3350394 | 60.271893 | 3350394 | 548604 | 6.107126 | 34454.022322991 | 0.01028357331 | 0.004465968 | 8 | 0.00105 |
2 | 2025-03-07 00:00:00.000 | 97595 | 6614962 | 67.779722 | 9965356 | 1100224 | 6.012377 | 74849.702051917 | 0.0113152127 | 0.004744324 | 52.5 | 0.00105 |
oxkimiaindependent-brown
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
21
›
⌄
-- 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
260B
4s