count(distinct(tx_id)) as txn_count,

sum(sales_amount) as total_sales_amount,

count(distinct (purchaser)) as buyer_count,

count(distinct seller) as seller_count

from solana.core.fact_nft_sales

where marketplace = 'hyperspace'

and succeeded = true