damidezdaily Active address
    Updated 2024-10-15
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    COUNT(DISTINCT sender) AS active_addresses
    FROM
    aptos.core.fact_transactions
    WHERE
    tx_type = 'user_transaction'
    AND success = TRUE
    AND block_timestamp >= '2024-01-01'
    AND block_timestamp < '2025-01-01'
    GROUP BY
    week
    ORDER BY
    week;



    Last run: 3 months ago
    WEEK
    ACTIVE_ADDRESSES
    1
    2024-01-01 00:00:00.000391974
    2
    2024-01-08 00:00:00.000435757
    3
    2024-01-15 00:00:00.000326459
    4
    2024-01-22 00:00:00.000550480
    5
    2024-01-29 00:00:00.000656162
    6
    2024-02-05 00:00:00.000560796
    7
    2024-02-12 00:00:00.000293753
    8
    2024-02-19 00:00:00.000404631
    9
    2024-02-26 00:00:00.000563292
    10
    2024-03-04 00:00:00.000619687
    11
    2024-03-11 00:00:00.000784982
    12
    2024-03-18 00:00:00.0001007164
    13
    2024-03-25 00:00:00.000678688
    14
    2024-04-01 00:00:00.000754566
    15
    2024-04-08 00:00:00.000559406
    16
    2024-04-15 00:00:00.000559119
    17
    2024-04-22 00:00:00.000447073
    18
    2024-04-29 00:00:00.000289661
    19
    2024-05-06 00:00:00.000351237
    20
    2024-05-13 00:00:00.000495381
    42
    1KB
    31s