count(DISTINCT from_address) as "Weekly users",

count(DISTINCT tx_hash) as "Weekly transactions"

from avalanche.core.fact_transactions

where status = 'SUCCESS'

and date_trunc('week',block_timestamp) != date_trunc('week',current_date())

group by 1

order by 1 desc