SELECT
COUNT(tx_hash) AS daily_sales_count,
DATE_TRUNC('month', block_timestamp) AS date
FROM ethereum.core.ez_nft_sales
WHERE
nft_address = lower('0xd2f668a8461d6761115daf8aeb3cdf5f40c532c6') --contract address for Karafuru NFT
AND
event_type = 'sale'
GROUP BY date --to group sales by month
ORDER BY date --to arrange things in descending order