cilo-pNEW USERS DAILY
    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('DAY',DATE ) as DAY ,
    COUNT(DISTINCT TX_SIGNER) as NUMBER_WALEETS
    FROM NEW_USERS
    GROUP BY 1
    ORDER BY 2
    Run a query to Download Data