DATE_TRUNC('month', first_tx_ts) as first_tx_month

, count(distinct address) as new_user

FROM (

SELECT

signers[0] as address, min(block_timestamp) as first_tx_ts

FROM solana.core.fact_transactions

WHERE succeeded = 'TRUE'

GROUP BY 1

GROUP BY first_tx_month