(select BLOCK_TIMESTAMP, NFT_TO_ADDRESS ,TOKENID ,MINT_PRICE_ETH ,MINT_PRICE_USD ,NFT_COUNT ,TX_FEE,tx_hash

from ethereum.core.ez_nft_mints

where NFT_ADDRESS='0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'

and EVENT_TYPE ='nft_mint'

and PROJECT_NAME='boredapeyachtclub'

and NFT_FROM_ADDRESS='0x0000000000000000000000000000000000000000')

select

count(distinct NFT_TO_ADDRESS) as minters ,

count(distinct tx_hash) as txhash ,

count(distinct TOKENID) as NFT_minted ,

sum(MINT_PRICE_ETH) as ETH ,

SUM(MINT_PRICE_USD) AS USD ,

SUM(TX_FEE) AS FEE ,

avg(MINT_PRICE_ETH) as avgETH ,

avg(MINT_PRICE_USD) AS avgUSD ,

avg(TX_FEE) AS avgFEE

FROM MINT