-- MetricsDAO Blockchain Analytics 101
-- https://docs.metricsdao.xyz/analyst-resources/blockchain-data-101
SELECT
NFT_TO_ADDRESS,
count(DISTINCT(TX_HASH))
FROM ethereum.core.ez_nft_mints
WHERE block_timestamp::DATE BETWEEN '2022-07-01' AND '2022-07-31'
group by 1
ORDER BY 2 DESC;