bobby_danielUser Activity and Growth
    Updated 2025-03-19
    WITH user_activity AS (
    SELECT
    DATE(block_timestamp) AS activity_date,
    COUNT(DISTINCT from_address) AS active_addresses,
    COUNT(DISTINCT tx_hash) AS total_transactions
    FROM monad.testnet.fact_transactions
    WHERE block_timestamp >= '2025-02-19 15:00'
    GROUP BY 1
    )
    SELECT
    activity_date,
    active_addresses,
    total_transactions,
    total_transactions / active_addresses AS txs_per_user
    FROM user_activity
    ORDER BY activity_date;
    Last run: 2 months ago
    ACTIVITY_DATE
    ACTIVE_ADDRESSES
    TOTAL_TRANSACTIONS
    TXS_PER_USER
    1
    2025-02-19 00:00:00.0001195158055876.740468
    2
    2025-02-20 00:00:00.000286530372824813.01172
    3
    2025-02-21 00:00:00.00046565944413379.537745
    4
    2025-02-22 00:00:00.000442354512362611.582637
    5
    2025-02-23 00:00:00.000552590953976917.263738
    6
    2025-02-24 00:00:00.000763550991101612.980179
    7
    2025-02-25 00:00:00.00012036921329559911.045682
    8
    2025-02-26 00:00:00.00021087052211732610.488582
    9
    2025-02-27 00:00:00.00014529391546425610.643431
    10
    2025-02-28 00:00:00.00012009251487236012.384087
    11
    2025-03-01 00:00:00.00011458691149640610.032915
    12
    2025-03-02 00:00:00.0001130708107434289.501505
    13
    2025-03-03 00:00:00.0001359838109076048.021253
    14
    2025-03-04 00:00:00.0001770914117839016.654135
    15
    2025-03-05 00:00:00.0001680721108155226.435049
    16
    2025-03-06 00:00:00.0001501760103920276.919899
    17
    2025-03-07 00:00:00.0001640739107526576.553545
    18
    2025-03-08 00:00:00.0001511389107089557.085505
    19
    2025-03-09 00:00:00.000129481495954397.41067
    20
    2025-03-10 00:00:00.00011826501190379610.065358
    29
    2KB
    75s