date_trunc('week',block_timestamp) as week,

count (distinct signers)

from solana.core.fact_transactions

where block_timestamp between '2022-01-01' and '2022-07-10'

group by 1