count(*) as sales,

count(DISTINCT TX_HASH ) as transactions,

count(DISTINCT SELLER_ADDRESS ) as total_sellers,

count (DISTINCT BUYER_ADDRESS) as total_buyers,

count(DISTINCT TOKEN_ID) as no_of_nfts,

sum(PRICE_USD) as sales_volume_usd,

min(PRICE_USD) as floor_price_usd,

max(PRICE_USD) as max_sale_price_usd,

avg(PRICE_USD) as avg_sale_price_usd,

sum(PRICE) as sales_volume_pol,

min(PRICE) as floor_price_pol,

avg(PRICE) as avg_sale_price_pol,

max(PRICE) as max_sale_price_pol,

FROM near.nft.ez_nft_sales

NFT_ADDRESS='tinkerunion_nft.enleap.near'