select
date_trunc('month', Block_timestamp) as "Date",
count(distinct tx_hash) as "Number of Mints",
count(distinct nft_to_address) as "Number of Minters",
count(distinct tokenid) as "Number Minted NFTs",
sum (mint_price_usd) as "Total Minted Volume (USD)",
avg (mint_price_usd) as "Average Minted Volume (USD)"
from ethereum.core.ez_nft_mints
where block_timestamp >= '2022-01-01' and block_timestamp <= '2022-12-30'
GROUP BY 1
ORDER BY 1