DATE | MONTH | transactions | active addresses | |
|---|---|---|---|---|
1 | 2024-08-19 00:00:00.000 | Aug | 2386283 | 6331 |
2 | 2024-08-05 00:00:00.000 | Aug | 2676080 | 6585 |
3 | 2024-12-30 00:00:00.000 | Jan | 1833751 | 4606 |
4 | 2024-08-26 00:00:00.000 | Aug | 1891207 | 5090 |
5 | 2024-11-25 00:00:00.000 | Dec | 417085 | 3390 |
6 | 2024-09-09 00:00:00.000 | Sep | 2218877 | 5644 |
7 | 2024-12-02 00:00:00.000 | Dec | 3087572 | 8144 |
8 | 2024-12-30 00:00:00.000 | Dec | 763990 | 2396 |
9 | 2024-09-16 00:00:00.000 | Sep | 2353686 | 6110 |
10 | 2025-01-06 00:00:00.000 | Jan | 1797303 | 3633 |
11 | 2024-08-12 00:00:00.000 | Aug | 2545615 | 6131 |
12 | 2024-12-23 00:00:00.000 | Dec | 2940044 | 5800 |
13 | 2024-12-16 00:00:00.000 | Dec | 3251171 | 6646 |
14 | 2024-07-29 00:00:00.000 | Aug | 1858803 | 4276 |
15 | 2024-10-07 00:00:00.000 | Oct | 2592292 | 6776 |
16 | 2024-09-23 00:00:00.000 | Sep | 2585468 | 6762 |
17 | 2024-09-30 00:00:00.000 | Oct | 1922441 | 5602 |
18 | 2024-08-26 00:00:00.000 | Sep | 261884 | 1694 |
19 | 2024-09-30 00:00:00.000 | Sep | 353985 | 1897 |
20 | 2024-11-04 00:00:00.000 | Nov | 2617395 | 7638 |
Moeaxl txns t
Updated 2024-12-22
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('week', BLOCK_TIMESTAMP)::date AS date,
monthname(BLOCK_TIMESTAMP) AS Month,
count(TX_id) AS "transactions ",
count(distinct TX_FROM) AS "active addresses "
from axelar.core.fact_transactions
where TX_SUCCEEDED='TRUE'
and BLOCK_TIMESTAMP between CURRENT_DATE - interval '6 months' and current_date
group by 1,2
Last run: 3 months ago
33
2KB
38s