DAY | DAILY_TX_COUNT | |
|---|---|---|
1 | 2024-11-27 00:00:00.000 | 27648 |
2 | 2024-11-28 00:00:00.000 | 43519 |
3 | 2024-11-29 00:00:00.000 | 43204 |
4 | 2024-11-30 00:00:00.000 | 43200 |
5 | 2024-12-01 00:00:00.000 | 43201 |
6 | 2024-12-02 00:00:00.000 | 43344 |
7 | 2024-12-03 00:00:00.000 | 44766 |
8 | 2024-12-04 00:00:00.000 | 45295 |
9 | 2024-12-05 00:00:00.000 | 45582 |
10 | 2024-12-06 00:00:00.000 | 45379 |
11 | 2024-12-07 00:00:00.000 | 44896 |
12 | 2024-12-08 00:00:00.000 | 44927 |
13 | 2024-12-09 00:00:00.000 | 45408 |
14 | 2024-12-10 00:00:00.000 | 45702 |
15 | 2024-12-11 00:00:00.000 | 45551 |
16 | 2024-12-12 00:00:00.000 | 45296 |
17 | 2024-12-13 00:00:00.000 | 45355 |
18 | 2024-12-14 00:00:00.000 | 45071 |
19 | 2024-12-15 00:00:00.000 | 44897 |
20 | 2024-12-16 00:00:00.000 | 45469 |
10Blockchaindirect-salmon
Updated 2025-03-04
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
DATE_TRUNC('DAY', block_timestamp) AS day,
COUNT(*) AS daily_tx_count
FROM swell.core.fact_transactions
-- Facultatif : filtrer uniquement les transactions "réussies"
WHERE tx_succeeded = TRUE
GROUP BY 1
ORDER BY day ASC
;
Last run: about 2 months ago
98
3KB
3s