-- forked from AnotherBlock Song Shares Minters & Mints @ https://flipsidecrypto.xyz/edit/queries/0c36c89d-1c87-4ae5-bce9-380731486f4d
with mints as (
select * from base.core.ez_nft_transfers
where nft_address in (
'0x0c664a85521d5721bca047d29238d9e2a9e9e861',
'0x33ed5107f821bb1465da30b7dce4fb7105b0ad16',
'0x8b2937ead425ccc91fc0ad884638dc2129c51cb2')
and event_type = 'mint')
select
date_trunc('hour', block_timestamp) as time,
project_name as Quest_NFT,
count(distinct nft_to_address) as Unique_minters,
count(tx_hash) as Total_mints
from mints
group by 1, 2