select buyer_address as Buyers,

sum (price_usd) as vol1,

sum(price) as voleth1

from ethereum.core.ez_nft_sales

where nft_address in ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb', -- CryptoPunks

'0xb7f7f6c52f2e2fdb1963eab30438024864c313f6') -- WPUNKS

and buyer_address != '0x0000000000000000000000000000000000000000'

and price_usd > 0 and price > 0

group by 1),

selltable as (

select seller_address as Seller,

sum (price_usd) as vol2,

sum (price) as voleth2

from ethereum.core.ez_nft_sales

where nft_address in ('0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb', -- CryptoPunks

'0xb7f7f6c52f2e2fdb1963eab30438024864c313f6') -- WPUNKS

and seller_address != '0x0000000000000000000000000000000000000000'

and price_usd > 0 and price > 0

group by 1)

select buyers as Trader,

sum (vol2-vol1) as profit_usd

from buytable a join selltable b on buyers = seller

group by 1

order by 2 DESC

limit 10