with minutes as (
select
date_trunc('minute', block_timestamp) as minute,
tx_from as sender,
count(distinct tx_id) as tx_count
from cosmos.core.fact_transactions
group by minute, sender
having tx_count > 2
)
select
date_trunc('week', minute) as week,
sum(tx_count) as transactions
from minutes
group by week
order by week asc