DAY | TOTAL_TX_COUNT | |
|---|---|---|
1 | 2023-07-02 00:00:00.000 | 2 |
2 | 2023-07-03 00:00:00.000 | 354 |
3 | 2023-07-04 00:00:00.000 | 275 |
4 | 2023-07-05 00:00:00.000 | 387 |
5 | 2023-07-06 00:00:00.000 | 273 |
6 | 2023-07-07 00:00:00.000 | 351 |
7 | 2023-07-08 00:00:00.000 | 296 |
8 | 2023-07-09 00:00:00.000 | 291 |
9 | 2023-07-10 00:00:00.000 | 335 |
10 | 2023-07-11 00:00:00.000 | 607 |
11 | 2023-07-12 00:00:00.000 | 564 |
12 | 2023-07-13 00:00:00.000 | 515 |
13 | 2023-07-14 00:00:00.000 | 495 |
14 | 2023-07-15 00:00:00.000 | 457 |
15 | 2023-07-16 00:00:00.000 | 379 |
16 | 2023-07-17 00:00:00.000 | 8313 |
17 | 2023-07-18 00:00:00.000 | 13488 |
18 | 2023-07-19 00:00:00.000 | 7568 |
19 | 2023-07-20 00:00:00.000 | 12410 |
20 | 2023-07-21 00:00:00.000 | 17793 |
10BlockchainA. Nombre total de transactions Mantle par jour
Updated 2025-02-24
9
1
2
3
4
5
6
7
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
COUNT(*) AS total_tx_count
FROM mantle.core.fact_transactions
GROUP BY 1
ORDER BY 1;
Last run: about 2 months ago
...
604
21KB
3s