m0rt3zaCryptopunks - top profitters wallet
Updated 2022-08-31Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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