SELECT
block_timestamp :: date as day,
hour(block_timestamp) as hour,
count(nft_to_address) as wallets_per_hour,
count(DISTINCT nft_to_address) AS distinct_minters
FROM ethereum.core.ez_nft_mints
WHERE nft_address = LOWER('0xe501afedfef8715471d8b4b4ebc3fd89034e5578')
AND block_timestamp :: date >= '2022-06-29'
GROUP BY day, hour