date_trunc('day', block_timestamp) as day,

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

from ethereum.core.ez_nft_mints

where nft_address ilike '0xBC4CA0EdA7647A8aB7C2061c2E118A18a936f13D'

group by day

order by day asc