COUNT(tx_hash) AS number_of_transactions,

SUM(mint_price_eth) AS total_mint_fee_eth,

SUM(mint_price_usd) AS total_mint_fees_usd,

DATE_TRUNC('day', block_timestamp) AS date

FROM ethereum.core.ez_nft_mints

WHERE

-- block_timestamp::date BETWEEN '2022-11-01' AND '2022-11-30'

-- DATE(block_timestamp) BETWEEN '2022-11-01' AND '2022-11-30'

-- DATE_TRUNC('day', block_timestamp) BETWEEN '2022-11-01' AND '2022-11-30'

nft_address = lower('0x49c36AFa15C7Fdbd57cE3D61D80F39b6615A76Ef')

GROUP BY date