SELECT TOKENID, MIN(BLOCK_TIMESTAMP) AS time_of_first_sale

FROM

ethereum.nft.ez_nft_sales s

INNER JOIN ethereum.nft.dim_nft_metadata m

ON s.tokenid=m.token_id

WHERE s.platform_name='opensea'

AND s.currency_symbol='ETH'

AND s.event_type='sale'

AND m.token_name LIKE '%cryptopunks%'

GROUP BY TOKENID

sum(s.total_fees) AS total_secondary_sales_in_ETH,

sum(s.total_fees_usd) AS total_secondary_sales_in_USD,

sum(s.creator_fee) AS commission_fees_in_eth,

sum(s.creator_fee_usd) AS commission_fees_in_usd

FROM ethereum.nft.ez_nft_sales AS s

INNER JOIN first_sale f

ON s.tokenid=f.tokenid

WHERE s.event_type='sale'

AND s.platform_name='opensea'

AND s.currency_symbol='ETH'

AND s.block_timestamp > f.time_of_first_sale