select
date(block_timestamp) as date,
count(distinct tx_hash) as tx_count,
count(distinct buyer_address) as active_buyers_wallets,
sum(price_usd) as usd_volume,
platform_name
from
ethereum.nft.ez_nft_sales
where
nft_address = lower('0xf9c362cdd6eeba080dd87845e88512aa0a18c615') and
date(block_timestamp) between current_date()-91 and current_date()-1
group by date, platform_name