Updated 2022-12-03
    with selltable as (
    select seller_address,
    sum (price_usd) as Total_USD_Volume
    from ethereum.core.ez_nft_sales
    where nft_address = '0xb2a3fe3d512c1e0102d85f89caab403b94b7d0de'
    and price_usd > 0
    group by 1),

    buytable as (
    select buyer_address,
    sum (price_usd) as Total_USD_Volume
    from ethereum.core.ez_nft_sales
    where nft_address = '0xb2a3fe3d512c1e0102d85f89caab403b94b7d0de'
    and price_usd > 0
    group by 1)

    select t1.seller_address,
    sum (t1.total_usd_volume - t2.total_usd_volume) as Profit
    from selltable t1 join buytable t2 on t1.seller_address = t2.buyer_address
    group by 1
    order by 2 DESC
    limit 10
    Run a query to Download Data