COUNT(distinct TX_hash)

FROM ethereum.core.ez_nft_mints

where Block_timestamp::Date between '2022-10-1' AND '2022-10-31'

group by 1

order by 2 DESC

limit 10