TRANSACTION_DATE | TOTAL_TRANSACTIONS | TOTAL_SUCCESS_TRANSACTIONS | TOTAL_FAILURE_TRANSACTIONS | CUMULATIVE_TRANSACTIONS | TPS | |
|---|---|---|---|---|---|---|
1 | 2025-03-01 00:00:00.000 | 5682909 | 5241932 | 440977 | 1964411249 | 65.77 |
2 | 2025-02-28 00:00:00.000 | 7465480 | 6645609 | 819871 | 1958728340 | 86.41 |
3 | 2025-02-27 00:00:00.000 | 6579937 | 5906675 | 673262 | 1951262860 | 76.16 |
4 | 2025-02-26 00:00:00.000 | 6503227 | 5768572 | 734655 | 1944682923 | 75.27 |
5 | 2025-02-25 00:00:00.000 | 6938837 | 6118318 | 820519 | 1938179696 | 80.31 |
6 | 2025-02-24 00:00:00.000 | 7331907 | 6334923 | 996984 | 1931240859 | 84.86 |
7 | 2025-02-23 00:00:00.000 | 6888172 | 6268715 | 619457 | 1923908952 | 79.72 |
8 | 2025-02-22 00:00:00.000 | 6979640 | 6453658 | 525982 | 1917020780 | 80.78 |
9 | 2025-02-21 00:00:00.000 | 7648319 | 6953195 | 695124 | 1910041140 | 88.52 |
10 | 2025-02-20 00:00:00.000 | 7817809 | 7283889 | 533920 | 1902392821 | 90.48 |
11 | 2025-02-19 00:00:00.000 | 6985593 | 6398379 | 587214 | 1894575012 | 80.85 |
12 | 2025-02-18 00:00:00.000 | 7054600 | 6348186 | 706414 | 1887589419 | 81.65 |
13 | 2025-02-17 00:00:00.000 | 6982001 | 6257930 | 724071 | 1880534819 | 80.81 |
14 | 2025-02-16 00:00:00.000 | 7154051 | 6526443 | 627608 | 1873552818 | 82.8 |
15 | 2025-02-15 00:00:00.000 | 6606909 | 5654248 | 952661 | 1866398767 | 76.47 |
16 | 2025-02-14 00:00:00.000 | 7342048 | 6634769 | 707279 | 1859791858 | 84.98 |
17 | 2025-02-13 00:00:00.000 | 8033031 | 7174618 | 858413 | 1852449810 | 92.97 |
18 | 2025-02-12 00:00:00.000 | 7652787 | 6490853 | 1161934 | 1844416779 | 88.57 |
19 | 2025-02-11 00:00:00.000 | 7268304 | 6118422 | 1149882 | 1836763992 | 84.12 |
20 | 2025-02-10 00:00:00.000 | 7521768 | 6317226 | 1204542 | 1829495688 | 87.06 |
moonshot21Number of Txs per Day
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
DATE(BLOCK_TIMESTAMP_HOUR) AS transaction_date,
SUM(TRANSACTION_COUNT) AS total_transactions,
SUM(TRANSACTION_COUNT_SUCCESS) AS total_success_transactions,
SUM(TRANSACTION_COUNT_FAILED) AS total_failure_transactions,
SUM(SUM(TRANSACTION_COUNT)) OVER (ORDER BY DATE(BLOCK_TIMESTAMP_HOUR)) AS cumulative_transactions,
ROUND(SUM(TRANSACTION_COUNT) / 86400, 2) AS tps -- Transactions per second
FROM base.stats.ez_core_metrics_hourly
GROUP BY DATE(BLOCK_TIMESTAMP_HOUR)
ORDER BY transaction_date DESC;
Last run: 1 day ago
...
626
39KB
2s