MONTH | TRANSACTIONS_PER_MONTH | CUMMULATIVE_TX | |
|---|---|---|---|
1 | 2025-04-01 00:00:00.000 | 15390453 | 2206456111 |
2 | 2025-03-01 00:00:00.000 | 232337318 | 2191065658 |
3 | 2025-02-01 00:00:00.000 | 208606867 | 1958728340 |
4 | 2025-01-01 00:00:00.000 | 331052827 | 1750121473 |
5 | 2024-12-01 00:00:00.000 | 262105536 | 1419068646 |
6 | 2024-11-01 00:00:00.000 | 221392662 | 1156963110 |
7 | 2024-10-01 00:00:00.000 | 181620489 | 935570448 |
8 | 2024-09-01 00:00:00.000 | 138901259 | 753949959 |
9 | 2024-08-01 00:00:00.000 | 122123562 | 615048700 |
10 | 2024-07-01 00:00:00.000 | 111112308 | 492925138 |
11 | 2024-06-01 00:00:00.000 | 90693463 | 381812830 |
12 | 2024-05-01 00:00:00.000 | 67203902 | 291119367 |
13 | 2024-04-01 00:00:00.000 | 82932613 | 223915465 |
14 | 2024-03-01 00:00:00.000 | 35413261 | 140982852 |
15 | 2024-02-01 00:00:00.000 | 13457390 | 105569591 |
16 | 2024-01-01 00:00:00.000 | 10993591 | 92112201 |
17 | 2023-12-01 00:00:00.000 | 9210868 | 81118610 |
18 | 2023-11-01 00:00:00.000 | 8679820 | 71907742 |
19 | 2023-10-01 00:00:00.000 | 16458222 | 63227922 |
20 | 2023-09-01 00:00:00.000 | 26056971 | 46769700 |
i_danBaseChain: Monthly Total Transaction Count Since Launch
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('month'
, block_timestamp) AS month
, COUNT(*) AS transactions_per_month
, SUM(transactions_per_month) OVER (ORDER BY month) AS cummulative_tx
FROM
base.core.fact_transactions
GROUP BY
DATE_TRUNC('month'
, block_timestamp)
ORDER BY
1 DESC
Last run: 1 day ago
23
1KB
170s