select date_trunc ('week',block_timestamp) as date,

sender as senders,

count (distinct tx_id) as transfer_count

from osmosis.core.fact_transfers

where tx_status = 'SUCCEEDED'

group by 1,2

having transfer_count >= 20)

select

date,

count (distinct senders) as active_senders

from tab

group by date