Movement Team1. Daily Active Addresses
    Updated 4 days ago
    select date_trunc('day',BLOCK_TIMESTAMP) as daily,
    count(DISTINCT SENDER) as "DAU",
    count(distinct tx_hash) as transactions,
    transactions/"DAU" as "Avg txn Per Address"
    from movement.core.fact_transactions
    where tx_type = 'user_transaction'
    group by 1

    Last run: 4 days ago
    DAILY
    DAU
    TRANSACTIONS
    Avg txn Per Address
    1
    2025-03-31 00:00:00.00069937065.30186
    2
    2025-02-13 00:00:00.000261465.615385
    3
    2025-02-17 00:00:00.000211517.190476
    4
    2025-03-19 00:00:00.0005894182843.102138
    5
    2025-03-15 00:00:00.00073763498.614654
    6
    2025-02-15 00:00:00.000201427.1
    7
    2025-03-14 00:00:00.00012051432311.886307
    8
    2024-12-20 00:00:00.000111691169
    9
    2025-02-04 00:00:00.000252.5
    10
    2025-03-22 00:00:00.00012351401611.348988
    11
    2025-03-02 00:00:00.00044242055
    12
    2025-02-16 00:00:00.0009525.777778
    13
    2025-01-10 00:00:00.00012424
    14
    2025-01-19 00:00:00.00012222
    15
    2025-03-28 00:00:00.0007192248643.457175
    16
    2024-12-30 00:00:00.00012222
    17
    2025-02-06 00:00:00.000111
    18
    2025-01-12 00:00:00.00012424
    19
    2025-03-20 00:00:00.00018802199611.7
    20
    2025-02-12 00:00:00.000271706.296296
    95
    4KB
    4s