DAY | TOTAL_TRANSACTIONS | |
|---|---|---|
1 | 2025-03-28 00:00:00.000 | 690 |
2 | 2025-03-29 00:00:00.000 | 2469 |
3 | 2025-03-30 00:00:00.000 | 3333 |
4 | 2025-03-31 00:00:00.000 | 1426 |
5 | 2025-04-01 00:00:00.000 | 1948 |
6 | 2025-04-02 00:00:00.000 | 2629 |
7 | 2025-04-03 00:00:00.000 | 3337 |
8 | 2025-04-04 00:00:00.000 | 5224 |
9 | 2025-04-05 00:00:00.000 | 4563 |
10 | 2025-04-06 00:00:00.000 | 2714 |
kentoTotal Transactions per Day
Updated 2025-04-06
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
DATE(block_timestamp) AS day,
COUNT(*) AS total_transactions
FROM mezo.testnet.fact_transactions
WHERE block_timestamp BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY day
ORDER BY day;
Last run: 27 days ago
10
330B
1s