select

date_trunc('day', block_timestamp) as date,

count (distinct tx_hash) as TX_Count,

count (distinct nft_to_address) as Minters_Count,

count (distinct tokenid) as Minted_Tokens,

sum (mint_price_usd) as Volume,

avg (mint_price_usd) as Average_Volume,

min (mint_price_usd) as min_Volume,

max (mint_price_usd) as max_Volume

from ethereum.core.ez_nft_mints

where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'

group by date