Month(DATE(flow.BLOCK_TIMESTAMP)) as block_date,

flow.BUYER,

flow.CURRENCY,

flow.NFT_COLLECTION,

flow.NFT_ID,

flow.PRICE,

flow.SELLER,

1 as count_sale

FROM flow.nft.ez_nft_sales flow

WHERE NFT_COLLECTION ='A.e3ad6030cbaff1c2.DimensionX'

and DATE(block_timestamp) > '12/31/2022'

ORDER BY flow.BLOCK_TIMESTAMP DESC