date_trunc('week', block_timestamp) as TIME,

contract_address,

count(tx_id) as sales_count,

count(distinct seller) as sellers_count,

count(distinct purchaser) as buyers_count,

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

from terra.core.fact_nft_sales

where TX_SUCCEEDED = 'TRUE'

and block_timestamp >= CURRENT_DATE - {{Past_X_Days}}

group by TIME, contract_address