select
count(distinct tx_hash) as Sales,
count(distinct buyer_address) as Buyers,
count(distinct seller_address) as Sellers,
count(distinct nft_address) as Collections,
count(distinct tokenid) as Tokens,
sum(price_usd) as Volume,
avg(price_usd) as Average_Price
from
base.nft.ez_nft_sales