DATE | transactions | active addresses | |
---|---|---|---|
1 | 2024-07-08 00:00:00.000 | 3382341 | 7961 |
2 | 2024-09-16 00:00:00.000 | 2353686 | 6110 |
3 | 2024-09-23 00:00:00.000 | 2585468 | 6762 |
4 | 2024-11-25 00:00:00.000 | 2994185 | 8387 |
5 | 2024-12-09 00:00:00.000 | 2965680 | 6853 |
6 | 2024-12-30 00:00:00.000 | 2597741 | 5619 |
7 | 2025-04-21 00:00:00.000 | 1801058 | 4454 |
8 | 2025-05-12 00:00:00.000 | 1904568 | 4452 |
9 | 2024-01-29 00:00:00.000 | 3071566 | 8338 |
10 | 2024-03-18 00:00:00.000 | 3913092 | 13688 |
11 | 2024-05-27 00:00:00.000 | 3478034 | 10557 |
12 | 2024-07-01 00:00:00.000 | 3020120 | 6802 |
13 | 2024-08-12 00:00:00.000 | 2545615 | 6131 |
14 | 2024-08-26 00:00:00.000 | 2153091 | 5603 |
15 | 2025-01-20 00:00:00.000 | 2669080 | 5942 |
16 | 2025-02-03 00:00:00.000 | 2527117 | 4863 |
17 | 2025-03-03 00:00:00.000 | 1918923 | 4808 |
18 | 2025-03-31 00:00:00.000 | 2133450 | 4478 |
19 | 2024-11-18 00:00:00.000 | 2840399 | 8556 |
20 | 2024-01-22 00:00:00.000 | 3134987 | 8497 |
m3jiWeekly Active Wallets
Updated 4 days agoCopy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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 >= '2024-01-01'
group by
1
Last run: 4 days agoAuto-refreshes every 12 hours
80
3KB
71s