SELECT

buyer_address,

SUM (price_usd) AS buy_price

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks' AND EVENT_TYPE = 'sale' AND Price_USD > 0

AND BUYER_ADDRESS != '0x0000000000000000000000000000000000000000' AND SELLER_ADDRESS != '0x0000000000000000000000000000000000000000'

AND BLOCK_TIMESTAMP >= '2021-01-01'

GROUP BY buyer_address),

sell AS (

SELECT

seller_address,

SUM (price_usd) AS sell_price

FROM ethereum.core.ez_nft_sales

WHERE project_name LIKE 'cryptopunks' AND EVENT_TYPE = 'sale' AND Price_USD > 0

AND BUYER_ADDRESS != '0x0000000000000000000000000000000000000000' AND SELLER_ADDRESS != '0x0000000000000000000000000000000000000000'

AND BLOCK_TIMESTAMP >= '2021-01-01'

GROUP BY seller_address)

SELECT

COALESCE (buyer_address, seller_address) AS Wallet,

sell_price AS sell_volume,

buy_price AS buy_volume,

sell_price - buy_price AS profit

FROM buy a join sell b on buyer_address = seller_address

ORDER BY profit DESC

LIMIT 10