SELECT

min(block_timestamp) AS date,

signers[0] AS "new uniqe user"

FROM solana.core.fact_transactions

WHERE INSTRUCTIONS[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

group by 2

order by 1 asc)

SELECT

date_trunc('day',date) as date,

COUNT(DISTINCT "new uniqe user") AS "new uiqe user"

FROM A

where date >= current_date - 60

GROUP BY 1

ORDER BY 1 ASC