DAY | TRANSACTIONS_PER_DAY | CUMMULATIVE_TX | |
|---|---|---|---|
1 | 2025-04-03 00:00:00.000 | 1396651 | 2206456111 |
2 | 2025-04-02 00:00:00.000 | 7299103 | 2205059460 |
3 | 2025-04-01 00:00:00.000 | 6694699 | 2197760357 |
4 | 2025-03-31 00:00:00.000 | 7514792 | 2191065658 |
5 | 2025-03-30 00:00:00.000 | 6940520 | 2183550866 |
6 | 2025-03-29 00:00:00.000 | 6820172 | 2176610346 |
7 | 2025-03-28 00:00:00.000 | 7103233 | 2169790174 |
8 | 2025-03-27 00:00:00.000 | 7000735 | 2162686941 |
9 | 2025-03-26 00:00:00.000 | 6848521 | 2155686206 |
10 | 2025-03-25 00:00:00.000 | 6946930 | 2148837685 |
11 | 2025-03-24 00:00:00.000 | 7241259 | 2141890755 |
12 | 2025-03-23 00:00:00.000 | 7293077 | 2134649496 |
13 | 2025-03-22 00:00:00.000 | 7654018 | 2127356419 |
14 | 2025-03-21 00:00:00.000 | 8420710 | 2119702401 |
15 | 2025-03-20 00:00:00.000 | 8265102 | 2111281691 |
16 | 2025-03-19 00:00:00.000 | 7785122 | 2103016589 |
17 | 2025-03-18 00:00:00.000 | 7470748 | 2095231467 |
18 | 2025-03-17 00:00:00.000 | 6940185 | 2087760719 |
19 | 2025-03-16 00:00:00.000 | 7590236 | 2080820534 |
20 | 2025-03-15 00:00:00.000 | 7062479 | 2073230298 |
i_danBaseChain: Daily Total Transaction Count Since Launch
Updated 2024-11-14
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
SELECT
DATE_TRUNC('day'
, block_timestamp) AS day
, COUNT(*) AS transactions_per_day
, SUM(transactions_per_day) OVER (ORDER BY day) AS cummulative_tx
FROM
base.core.fact_transactions
GROUP BY
DATE_TRUNC('day'
, block_timestamp)
ORDER BY
1 DESC
Last run: 1 day ago
...
659
29KB
80s