mohammadh4)Cryptopunk Sales and Traders (top 10 nft with trade volume)
    Updated 2022-08-30
    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
    Run a query to Download Data