list as (

select signers[0] as tx_signer, date_trunc('day', min(a.block_timestamp)) as date_created

from solana.core.fact_nft_sales a join solana.core.fact_transactions using(tx_id)

where a.succeeded = 1

and a.block_timestamp >= current_date - interval '3 months'

group by tx_signer

date_created as day,

count(distinct(tx_signer)) as wallets_number,

sum(wallets_number) over(order by day asc) as comulative_users

from list

group by day

order by day asc