select
sum(PRICE_USD) as usd_volume,
TOKENID,
count(Distinct TX_HASH) as tx_count,
usd_volume/tx_count as avg_price
from ethereum.core.ez_nft_sales
where project_name = 'cryptopunks' and event_type = 'sale'
and PRICE_USD > 0
group by TOKENID
order by usd_volume DESC
LIMIT 10