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('0x5470da6d5b35c4a0be5243822db7cf6f861f13e6')

group by 1

order by 2 desc