Cryptoside📌 SQL queries for analyzing user activity on Avalanche in the last 10 weeks
    Updated 2025-04-29
    WITH weekly_activity AS (
    SELECT
    DATE_TRUNC('week', block_timestamp) AS week,
    COUNT(tx_hash) AS transaction_count,
    COUNT(DISTINCT from_address) AS unique_users
    FROM avalanche.core.fact_transactions
    WHERE block_timestamp >= DATEADD(week, -10, CURRENT_DATE)
    GROUP BY 1
    ORDER BY 1
    )
    SELECT * FROM weekly_activity;
    Last run: 2 months ago
    WEEK
    TRANSACTION_COUNT
    UNIQUE_USERS
    1
    2025-02-17 00:00:00.0001958274153803
    2
    2025-03-03 00:00:00.0002938659158514
    3
    2025-03-10 00:00:00.0002386167225223
    4
    2025-04-14 00:00:00.0001700946118255
    5
    2025-04-07 00:00:00.0002176595131464
    6
    2025-03-17 00:00:00.0001809264170770
    7
    2025-04-21 00:00:00.0002157813164388
    8
    2025-04-28 00:00:00.00040420759336
    9
    2025-03-24 00:00:00.0002169322506409
    10
    2025-03-31 00:00:00.0001780054134530
    11
    2025-02-24 00:00:00.0002818020333347
    11
    472B
    12s