date_trunc(week,block_timestamp)::date as date

,upper(replace(tx_type,'_',' ')) as Type

,count(DISTINCT tx_hash) as TXs

from aptos.core.fact_transactions

where success

group by 1,2

order by 1