WEEK | WAU | |
|---|---|---|
1 | 2025-02-03 00:00:00.000 | 924202 |
2 | 2025-01-27 00:00:00.000 | 1749983 |
3 | 2025-01-20 00:00:00.000 | 1594278 |
4 | 2025-01-13 00:00:00.000 | 1421357 |
5 | 2025-01-06 00:00:00.000 | 1184976 |
Movement TeamWeekly Active Users
Updated 2025-02-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
with tb1 as (
Select
date_trunc('week', BLOCK_TIMESTAMP) as week,
SENDER,
count(*) as no_txn
from
aptos.core.fact_transactions
where
BLOCK_TIMESTAMP >= current_date - 30
group by
1,
2
)
select
week,
count(distinct sender) as WAU
from
tb1
where
no_txn >= 3
group by
1
order by
1 desc
Last run: 3 months ago
5
180B
16s