select signers[0] address,

MIN (BLOCK_TIMESTAMP)::date Min_date

from solana.core.fact_transactions

where INSTRUCTIONS[0]:programId = 'HubbLeXBb7qyLHt3x7gvYaRrxQmmgExb7fCJgDqFuB6T'

and succeeded = true

group by 1

select Min_date daily,

count ( address) num_new_users,

sum (num_new_users) over (order by daily) cum_new_users

from first_action

group by 1