count(TX_HASH) as mint_cnt,

count(distinct nft_to_address) as minter_cnt,

sum(MINT_PRICE_ETH) as volume,

sum(mint_price_usd) as volume_usd,

date(max(block_timestamp))-date(min(block_timestamp)) as mint_duration

from ethereum.core.ez_nft_mints

where nft_address ilike '0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D'