date_trunc('week', block_timestamp) as week,

sum(sales_amount)/pow(10, 6) as total_sales

from terra.core.fact_nft_sales

group by week

order by week asc