Updated 2022-08-31
    with tx1 as (
    SELECT ADDRESS
    from ethereum.core.dim_labels
    where LABEL_TYPE = 'nft'
    and LABEL ilike '%cryptopunk%'
    )
    SELECT SELLER_ADDRESS , COUNT(*) as "Number of transaction" ,
    sum(A.PRICe) as "Volume in ETH" ,sum(A.PRICe_USD) as "Volume in USD"
    from tx1 B , ethereum.core.ez_nft_sales A
    where NFT_ADDRESS = ADDRESS
    and ( BUYER_ADDRESS <> '0x0000000000000000000000000000000000000000' )
    and (CURRENCY_SYMBOL = 'ETH'
    or CURRENCY_SYMBOL = 'WETH')
    and SELLER_ADDRESS <> '0x9b5a5c5800c91af9c965b3bf06ad29caa6d00f9b'
    and PRICe_USD is not null
    group by 1
    order by 4 desc
    limit 10

    Run a query to Download Data