DATE | TRANSACTION_COUNT | CUMULATIVE_TRANSACTION_COUNT | |
|---|---|---|---|
1 | 2025-01-19 00:00:00.000 | 48722 | 2477726 |
2 | 2024-11-30 00:00:00.000 | 43200 | 157571 |
3 | 2025-03-14 00:00:00.000 | 46509 | 5096673 |
4 | 2025-02-13 00:00:00.000 | 48480 | 3696107 |
5 | 2025-02-17 00:00:00.000 | 48469 | 3890729 |
6 | 2024-11-27 00:00:00.000 | 27648 | 27648 |
7 | 2025-03-02 00:00:00.000 | 48554 | 4515203 |
8 | 2025-01-10 00:00:00.000 | 47464 | 2050394 |
9 | 2025-03-22 00:00:00.000 | 46201 | 5469307 |
10 | 2025-02-16 00:00:00.000 | 48343 | 3842260 |
11 | 2025-02-04 00:00:00.000 | 49862 | 3262168 |
12 | 2024-12-20 00:00:00.000 | 47698 | 1064213 |
13 | 2025-02-15 00:00:00.000 | 49040 | 3793917 |
14 | 2025-03-15 00:00:00.000 | 45948 | 5142621 |
15 | 2025-03-19 00:00:00.000 | 47298 | 5329607 |
16 | 2025-02-27 00:00:00.000 | 48830 | 4370318 |
17 | 2025-02-23 00:00:00.000 | 46982 | 4175232 |
18 | 2025-03-03 00:00:00.000 | 49382 | 4564585 |
19 | 2024-12-06 00:00:00.000 | 45379 | 425138 |
20 | 2024-12-05 00:00:00.000 | 45582 | 379759 |
rezarwzTransactions & Cumulative Transactions
Updated 2025-03-28
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc('{{Time_Frame}}', block_timestamp) as Date,
COUNT(tx_hash) as transaction_count,
SUM(transaction_count) OVER (
ORDER BY
Date asc
) AS cumulative_transaction_count
FROM
swell.core.fact_transactions
where
TX_SUCCEEDED = TRUE
group by
1
Last run: 17 days ago
...
122
5KB
2s