block_timestamp,

date_trunc('day', block_timestamp),

block_timestamp::date

from ethereum.core.ez_nft_mints

where date_trunc('month', block_timestamp) = '2022-10-01'

--and block_timestamp between '2022-10-01' and '2022-11-01'

and nft_address = lower('0x57f1887a8BF19b14fC0dF6Fd9B2acc9Af147eA85')

and tx_hash = '0xd9f1df3ff25b39d9be5d51fcb77d06682ba2c70b75129b3f8ec32a6a74fddc15'