SELECT
count(DISTINCT tx_id) number_of_sales,
count(DISTINCT nft_id) number_of_traded_nft,
count(DISTINCT buyer) number_of_buyers,
count(DISTINCT seller) number_of_sellers,
sum(price) Total_sales_volume,
avg(price) avg_price,
min(price) min_price,
max(price) max_price,
median (price ) median_price
from
flow.core.ez_nft_sales
where
nft_collection = 'A.e3ad6030cbaff1c2.DimensionX'
and tx_succeeded = true