flipside

    4.5)Cryptopunk Sales and Traders (Top 10 NFTs in terms of number of transactions and their average price)
    mohammadh4.5)Cryptopunk Sales and Traders (Top 10 NFTs in terms of number of transactions and their average price)
    Updated 2022-08-30
    select
    count(distinct TX_HASH) as tx_count,
    TOKENID,
    avg(PRICE_USD) as avg_price
    from ethereum.core.ez_nft_sales
    where (PROJECT_NAME = 'cryptopunks' and NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' or NFT_ADDRESS='0xb7f7f6c52f2e2fdb1963eab30438024864c313f6' and PROJECT_NAME='wrapped cryptopunks')
    and PRICE_USD > 0
    group by TOKENID
    order by tx_count desc
    LIMIT 10

    Run a query to Download Data