cilo-pNEW USERS WEEKLY
    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
    GROUP BY TX_SIGNER )

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