doyinsoextraMonthly sales count
    Updated 2023-02-04
    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