count(DISTINCT tx_hash) as sales,

count(DISTINCT SELLER_ADDRESS)as sellers,

count(DISTINCT buyer_address) as buyers,

count(DISTINCT tokenid) as nfts,

avg(price_usd) as avg_price,

sum(PRICE_USD) as usd_sale_vol,

MIN(price_usd) AS min_price,

MAX(price_usd) AS max_price

from ethereum.core.ez_nft_sales

where NFT_ADDRESS = lower ('0x60bb1e2AA1c9ACAfB4d34F71585D7e959f387769')

and event_type = 'sale'

group by 1, 2