ramishoowNew NEAR Users
    Updated 2022-09-07
    WITH new_users AS ( SELECT MIN(block_timestamp) AS first_trasaction, tx_signer FROM near.core.fact_transactions GROUP BY 2 HAVING first_trasaction::DATE >= '2022-06-08' )
    --'2022-06-08'
    SELECT first_trasaction::DATE AS DAY, COUNT(tx_signer) AS neew_users FROM new_users GROUP BY 1 ORDER BY 1
    Run a query to Download Data