COUNT(DISTINCT 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('0x59468516a8259058baD1cA5F8f4BFF190d30E066')

GROUP BY date