SUM (PRICE) AS BUYPRICE

FROM ethereum.core.ez_nft_sales

WHERE EVENT_TYPE ILIKE 'sale'

AND NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

AND PRICE IS NOT NULL GROUP BY USER),

SELLERS AS (SELECT SELLER_ADDRESS AS USER,

SUM (PRICE) AS SELLPRICE

FROM ethereum.core.ez_nft_sales

WHERE EVENT_TYPE ILIKE 'sale'

AND NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'

AND PRICE IS NOT NULL GROUP BY USER)

SELECT S.USER, SUM (SELLPRICE - BUYPRICE) AS NETETHVOLUME

FROM SELLERS S JOIN BUYERS B USING (USER)

GROUP BY USER

ORDER BY NETETHVOLUME DESC

LIMIT 10