count(distinct tx_id) as number_of_sales,

count(distinct nft_id) as number_of_unique_nft_sales,

count(distinct buyer) as number_of_unique_buyer,

count(distinct seller) as number_of_unique_seller

from flow.core.fact_nft_sales

where block_timestamp::date >= '2022-05-09'

and tx_succeeded = true