BUYER_ADDRESS ,

count(distinct tx_hash) as nft_sales ,

count(distinct tokenid) ,

sum(price_usd) as price_usd

from ethereum.core.ez_nft_sales

where project_name = 'cryptopunks'

AND block_timestamp >= '2023-01-01'

and event_type = 'sale'

and price_usd is not null

group by 1

order by 4 desc

offset 1 rows FETCH first 10 rows only