select
count (distinct tx_hash) as events,
count (distinct buyer_address) as buyers,
count (distinct nft_address) as n_collections,
count (distinct tokenid) as n_tokens,
sum (price_usd) as total_sales_usd,
avg (price_usd) as average_sales_usd
from ethereum.core.ez_nft_sales
where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'
and platform_name = 'opensea'