select --BLOCK_TIMESTAMP::date as day

sum(PRICE_USD) as volume

,avg(PRICE_USD) as avg_volume

,count(distinct TX_HASH) as trades

,count(distinct BUYER_ADDRESS) as buyers

,count(distinct SELLER_ADDRESS) as sellers

,count(distinct TOKEN_ID) as sold_token

from near.nft.ez_nft_sales

where PLATFORM_NAME='TradePort'