with final as ( select trunc(block_timestamp,'week') as date, TX_SIGNER, count(DISTINCT(tx_hash)) as total_tx
from near.core.fact_transactions
where tx_signer in ( select tx_signer from near.core.fact_transactions
where tx_receiver = 'nethmap.near'
and block_timestamp >= '2022-12-19')
and date >= '2022-12-19'
group by 1,2)
select date, avg(total_tx) as avg_tx
from final
group by 1