flipside

    NEAR Users Count
    feyikemiNEAR Users Count
    Updated 2025-03-25
    WITH transactions AS (
    SELECT
    block_timestamp,
    tx_signer AS user
    FROM near.core.fact_transactions
    WHERE TX_SUCCEEDED = TRUE
    UNION
    SELECT
    block_timestamp,
    tx_receiver AS user
    FROM near.core.fact_transactions
    WHERE TX_SUCCEEDED = TRUE
    ),

    first_tx_time AS (
    SELECT
    MIN(block_timestamp) AS first_tx_time,
    user
    FROM transactions
    GROUP BY user
    ),

    daily_user_counts AS (
    SELECT
    DATE_TRUNC('day', first_tx_time) AS daily,
    COUNT(DISTINCT user) AS users,
    FROM first_tx_time
    WHERE first_tx_time::date >= '2024-01-01'
    GROUP BY daily
    )

    SELECT
    AVG(users) AS avg_users,
    SUM(users) AS total_users
    FROM daily_user_counts

    Last run: 2 months ago
    AVG_USERS
    TOTAL_USERS
    1
    		299830.877778134923895
    1
    27B
    492s