select
date_trunc('month',block_timestamp) as date,
count(distinct tx_hash) as number_mint,
sum(mint_price_usd) as mint_amount,
project_name
from ethereum.core.ez_nft_mints
where block_timestamp between '2022-01-01' and '2022-12-29'
and event_type = 'nft_mint'
group by 1,4