monadmetrics-JFe1_RNew Wallets Count in 24-Hour Intervals (Auto-Updated Daily)
    Updated 2025-02-21
    WITH new_wallets AS (
    SELECT
    DATE_TRUNC('day', block_timestamp) AS day,
    COUNT(DISTINCT from_address) AS total_new_wallets
    FROM MONAD.testnet.fact_transactions
    WHERE block_timestamp >= '2025-02-19 15:00:00.000'
    GROUP BY 1
    )
    SELECT
    day,
    total_new_wallets
    FROM new_wallets
    ORDER BY day DESC
    LIMIT 1
    QueryRunArchived: QueryRun has been archived