m0rt3zaCryptopunks - top profitters wallet
    Updated 2022-08-31
    WITH buyers AS (
    SELECT buyer_address,
    sum(price_usd) as buys
    FROM ethereum.core.ez_nft_sales
    WHERE project_name in ('cryptopunks', 'Wrapped CryptoPunks V1', 'wrapped cryptopunks')
    --AND block_timestamp > CURRENT_DATE - 365
    GROUP BY buyer_address
    ), sellers AS (
    SELECT seller_address,
    sum(price_usd) as sells
    FROM ethereum.core.ez_nft_sales
    WHERE project_name in ('cryptopunks', 'Wrapped CryptoPunks V1', 'wrapped cryptopunks')
    --AND block_timestamp > CURRENT_DATE - 365
    GROUP BY seller_address
    )
    SELECT a.seller_address as wallet,
    a.sells - b.buys as profit
    FROM sellers as a JOIN buyers as b ON b.buyer_address = a.seller_address
    WHERE profit > 0
    ORDER BY profit DESC
    LIMIT 10
    Run a query to Download Data