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