Movement TeamDaily Active Users
    Updated 2025-02-06
    with tb1 as (
    Select
    date_trunc('day', BLOCK_TIMESTAMP) as day,
    SENDER,
    count(*) as no_txn
    from
    aptos.core.fact_transactions
    where
    BLOCK_TIMESTAMP >= current_date - 7
    group by
    1,
    2
    )
    select
    day,
    count(distinct sender) as DAU
    from
    tb1
    where
    no_txn >= 1
    group by
    1
    order by
    1 desc
    Last run: about 2 months ago
    DAY
    DAU
    1
    2025-02-06 00:00:00.0001065298
    2
    2025-02-05 00:00:00.0001114560
    3
    2025-02-04 00:00:00.0001182537
    4
    2025-02-03 00:00:00.0001193815
    5
    2025-02-02 00:00:00.0001392325
    6
    2025-02-01 00:00:00.0001574383
    7
    2025-01-31 00:00:00.0001491133
    8
    2025-01-30 00:00:00.0001603118
    8
    289B
    6s