count(distinct tx_hash) as "Total Number of Mints",

count(distinct nft_to_address) as "Number of Minters",

count(distinct nft_address) as "Number of Projects",

count(distinct tokenid) as "Total Number of Minted NFTs",

sum (mint_price_usd) as "Total Minted Volume (USD)",

avg (mint_price_usd) as "Average Minted Volume (USD)",

max (mint_price_usd) as "Maximum Minted Volume (USD)"

from ethereum.core.ez_nft_mints

where block_timestamp >= '2022-01-01' and block_timestamp <= '2022-12-30'