count (distinct buyer_address) as buyers,

count (distinct seller_address) as sellers,

sum(price) as total_sales_volume_ETH,

min(price) as FLOOR,

max(price) as ceiling,

avg(price) as average_price,

median(price) as median_price,

sum(creator_fee) as royalties_ETH,

sum(creator_fee_usd) as royalties_USD

FROM ethereum.core.ez_nft_sales

WHERE nft_address = '0x49cf6f5d44e70224e2e23fdcdd2c053f30ada28b'

and currency_symbol like 'ETH'