select date_trunc(day,block_timestamp) as date,

date_trunc(week,block_timestamp) as date2,

date_trunc(month,block_timestamp) as date3,

count (distinct tx_hash) as Mints_Count,

count (distinct nft_to_address) as Minters_Count,

count (distinct tokenid) as Minted_Tokens,

sum (mint_price_usd) as Volume

from ethereum.core.ez_nft_mints

where nft_address = '0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'

group by 1,2,3

order by 1