SELECT

TOKENID,

MIN(BLOCK_TIMESTAMP) AS FirstSaleTime

FROM

ethereum.nft.ez_nft_sales e

WHERE

e.PROJECT_NAME LIKE '%Cryptopunks%'

OR e.PROJECT_NAME LIKE '%cryptopunks%'

GROUP BY

TOKENID

e.AGGREGATOR_NAME,

e.BLOCK_NUMBER,

e.BLOCK_TIMESTAMP,

e.BUYER_ADDRESS,

e.CREATOR_FEE,

e.CREATOR_FEE_USD,

e.CURRENCY_ADDRESS,

e.CURRENCY_SYMBOL,

e.ERC1155_VALUE,

e.EVENT_TYPE,

e.NFT_ADDRESS,

e.ORIGIN_FROM_ADDRESS,

e.ORIGIN_FUNCTION_SIGNATURE,

e.ORIGIN_TO_ADDRESS,

e.PLATFORM_ADDRESS,

e.PLATFORM_EXCHANGE_VERSION,

e.PLATFORM_FEE,

e.PLATFORM_FEE_USD,

e.PLATFORM_NAME,

e.PRICE,

e.PRICE_USD,

e.PROJECT_NAME,