cilo-pNEW USERS MONTHLY
    Updated 2022-09-07
    with NEW_USERS as
    (SELECT TX_SIGNER ,
    MIN(block_timestamp) as DATE
    from near.core.fact_transactions
    where BLOCK_TIMESTAMP > CURRENT_DATE -90
    --and TX_SIGNER >0
    GROUP BY TX_SIGNER )

    SELECT
    date_trunc('MONTH',DATE ) as MONTH ,
    COUNT(DISTINCT TX_SIGNER) as NUMBER_WALEETS
    FROM NEW_USERS
    GROUP BY 1
    ORDER BY 2
    Run a query to Download Data