SELECT date(BLOCK_TIMESTAMP),
avg(AMOUNT_USD)*COUNT(DISTINCT(TX_HASH)) as noun_value
FROM ethereum.core.ez_eth_transfers
WHERE TX_HASH IN (SELECT TX_HASH
FROM ethereum.core.ez_nft_mints
WHERE NFT_ADDRESS = lower('0x9C8fF314C9Bc7F6e59A9d9225Fb22946427eDC03')
AND TOKENID NOT LIKE '%0'
GROUP by 1)
GROUP by 1
ORDER by 1