chispasTop y00ts Traders
Updated 2023-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH TRADERS AS (
SELECT
BUYER_ADDRESS AS "Trader Wallets",
SUM(PRICE_USD) AS TOTAL_BUY_AMOUNT,
0 AS TOTAL_SELL_AMOUNT,
0 AS USD_PROFIT
FROM
POLYGON.nft.ez_nft_sales
WHERE
EVENT_TYPE = 'sale'
AND NFT_ADDRESS = '0x670fd103b1a08628e9557cd66b87ded841115190' -- y00ts
AND PRICE_USD IS NOT NULL
GROUP BY
"Trader Wallets"
UNION ALL
SELECT
SELLER_ADDRESS AS "Trader Wallets",
0 AS TOTAL_BUY_AMOUNT,
SUM(PRICE_USD) AS TOTAL_SELL_AMOUNT,
0 AS USD_PROFIT
FROM
POLYGON.nft.ez_nft_sales
WHERE
EVENT_TYPE = 'sale'
AND NFT_ADDRESS = '0x670fd103b1a08628e9557cd66b87ded841115190'
AND PRICE_USD IS NOT NULL
GROUP BY
"Trader Wallets"
)
SELECT
"Trader Wallets",
SUM(TOTAL_BUY_AMOUNT) AS TOTAL_BUY_AMOUNT,
SUM(TOTAL_SELL_AMOUNT) AS TOTAL_SELL_AMOUNT,
SUM(TOTAL_SELL_AMOUNT - TOTAL_BUY_AMOUNT) AS USD_PROFIT
FROM
TRADERS
Run a query to Download Data