DATE | TRANSACTION_COUNT | CUMULATIVE_TRANSACTION_COUNT | |
|---|---|---|---|
1 | 2025-04-26 00:00:00.000 | 60685 | 7148676 |
2 | 2024-12-20 00:00:00.000 | 47698 | 1064213 |
3 | 2025-04-25 00:00:00.000 | 47558 | 7087991 |
4 | 2025-02-04 00:00:00.000 | 49862 | 3262168 |
5 | 2025-03-02 00:00:00.000 | 48554 | 4515203 |
6 | 2025-03-22 00:00:00.000 | 46201 | 5469307 |
7 | 2025-02-16 00:00:00.000 | 48343 | 3842260 |
8 | 2025-01-10 00:00:00.000 | 47464 | 2050394 |
9 | 2025-01-19 00:00:00.000 | 48722 | 2477726 |
10 | 2024-11-30 00:00:00.000 | 43200 | 157571 |
11 | 2025-03-14 00:00:00.000 | 46509 | 5096673 |
12 | 2025-02-15 00:00:00.000 | 49040 | 3793917 |
13 | 2025-03-15 00:00:00.000 | 45948 | 5142621 |
14 | 2025-03-19 00:00:00.000 | 47298 | 5329607 |
15 | 2025-04-12 00:00:00.000 | 46763 | 6474084 |
16 | 2025-04-16 00:00:00.000 | 47824 | 6662623 |
17 | 2025-03-31 00:00:00.000 | 48321 | 5895958 |
18 | 2024-11-27 00:00:00.000 | 27648 | 27648 |
19 | 2025-02-13 00:00:00.000 | 48480 | 3696107 |
20 | 2025-02-17 00:00:00.000 | 48469 | 3890729 |
rezarwzTransactions & Cumulative Transactions
Updated 1 hour ago
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: about 1 hour ago
...
152
6KB
2s