date_trunc('week',block_timestamp) date

,count (distinct FROM_ADDRESS) "Active users"

from aurora.core.fact_transactions

Where date >= '2023-01-01'

group by 1

order by date asc