⏰ Time | 💫 Hourly Transactions | 👛 Unique Wallets per Hour | 📈 Cumulative Transactions | 📊 24-Hour Moving Average | |
|---|---|---|---|---|---|
1 | 2025-03-10 15:00:00.000 | 420708 | 82575 | 420708 | 420708 |
2 | 2025-03-10 16:00:00.000 | 628856 | 94515 | 1049564 | 524782 |
3 | 2025-03-10 17:00:00.000 | 770926 | 112361 | 1820490 | 606830 |
4 | 2025-03-10 18:00:00.000 | 710041 | 101177 | 2530531 | 632632.75 |
5 | 2025-03-10 19:00:00.000 | 575331 | 95554 | 3105862 | 621172.4 |
6 | 2025-03-10 20:00:00.000 | 625174 | 88930 | 3731036 | 621839.333 |
7 | 2025-03-10 21:00:00.000 | 618267 | 76052 | 4349303 | 621329 |
8 | 2025-03-10 22:00:00.000 | 699714 | 82167 | 5049017 | 631127.125 |
9 | 2025-03-10 23:00:00.000 | 630396 | 100772 | 5679413 | 631045.888 |
10 | 2025-03-11 00:00:00.000 | 636269 | 92893 | 6315682 | 631568.2 |
11 | 2025-03-11 01:00:00.000 | 638128 | 83390 | 6953810 | 632164.545 |
12 | 2025-03-11 02:00:00.000 | 736698 | 109670 | 7690508 | 640875.666 |
13 | 2025-03-11 03:00:00.000 | 725204 | 103117 | 8415712 | 647362.461 |
14 | 2025-03-11 04:00:00.000 | 859228 | 140726 | 9274940 | 662495.714 |
15 | 2025-03-11 05:00:00.000 | 780116 | 110271 | 10055056 | 670337.066 |
16 | 2025-03-11 06:00:00.000 | 881753 | 120897 | 10936809 | 683550.562 |
17 | 2025-03-11 07:00:00.000 | 884286 | 129752 | 11821095 | 695358.529 |
18 | 2025-03-11 08:00:00.000 | 985683 | 134612 | 12806778 | 711487.666 |
19 | 2025-03-11 09:00:00.000 | 1028598 | 126107 | 13835376 | 728177.684 |
20 | 2025-03-11 10:00:00.000 | 1019720 | 116173 | 14855096 | 742754.8 |
Monad Data Engineodd-bronze
Updated 2025-03-11
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
WITH hourly_transactions AS (
SELECT
DATE_TRUNC('hour', block_timestamp) AS hour,
COUNT(*) AS transaction_count,
COUNT(DISTINCT from_address) AS unique_wallets
FROM MONAD.testnet.fact_transactions
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '24 hours'
GROUP BY 1
)
SELECT
hour AS "⏰ Time",
transaction_count AS "💫 Hourly Transactions",
unique_wallets AS "👛 Unique Wallets per Hour",
SUM(transaction_count) OVER (ORDER BY hour) AS "📈 Cumulative Transactions",
AVG(transaction_count) OVER (ORDER BY hour ROWS BETWEEN 23 PRECEDING AND CURRENT ROW) AS "📊 24-Hour Moving Average"
FROM hourly_transactions
ORDER BY hour;
Last run: 18 days ago
24
1KB
1s