select
block_timestamp :: date as sale_date,
count(distinct seller_address) as unique_seller_count,
count(distinct buyer_address) as unique_buyer_count
from
ethereum.nft.ez_nft_sales
where
nft_address = '0x0fc3dd8c37880a297166bed57759974a157f0e74'
and block_timestamp :: date >= dateadd('day', - {{n_days}}, current_date)
and block_timestamp :: date < current_date
and price_usd > 0
group by
1
order by
1 desc