where price_usd is not null and price_usd > 0 and label like 'cryptopunks' and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' group by 1,tokenid), seller as ( select seller_address as sellers,

sum(price_usd) as sell_volume,tokenid from ethereum.core.ez_nft_sales left outer join ethereum.core.dim_labels on nft_address = address where price_usd is not null and price_usd > 0

and label like 'cryptopunks' and tx_hash != '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0' group by 1,tokenid) select buyers, sum(sell_volume - buy_volume) as profit

from seller left outer join ramishoow on sellers = buyers and ramishoow.tokenid = seller.tokenid where sell_volume is not null and buy_volume is not null group by 1 order by 2 DESC limit 10