-- forked from Day 8 NFTs @ https://flipsidecrypto.xyz/edit/queries/74c65415-7e01-412d-a524-a1a675f636ed

with mints as (

select * from base.core.ez_nft_transfers

where nft_address in (

and event_type = 'mint')

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,

Total_mints * 0.000777 as Earnings

from mints

group by 1, 2