count (distinct buyer_address) as buyers,

count (distinct seller_address) as sellers,

sum(price) as total_sales_volume_ETH,

sum(price_usd) as total_sales_volume_USD,

min(price) as floor_ETH,

min(price_usd) as floor_USD,

max(price) as ceiling_ETH,

max(price_usd) as ceiling_USD,

avg(price) as average_price_ETH,

avg(price_usd) as average_price_USD,

median(price) as median_price_ETH,

median(price_usd) as median_price_USD,

sum(creator_fee) as royalties_ETH,

sum(creator_fee_usd) as royalties_USD

FROM ethereum.core.ez_nft_sales

WHERE nft_address = '0x60e4d786628fea6478f785a6d7e704777c86a7c6' --MAYC contract address

AND currency_symbol like 'ETH'