DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,

count(distinct BUYER_ADDRESS) AS BUYERS ,

count(distinct SELLER_ADDRESS ) * -1 AS SELLERS ,

count(distinct tx_hash) as nft_sales ,

count(distinct tokenid) ,

sum(price) as price_eth,

sum(price_usd) as price_usd

from base.nft.ez_nft_sales

where nft_address = lower('0x6e230533d53e2f8fb90c542f02e5fa306b1fe1d3')

group by 1

order by 2 desc