2844made the most profit
Updated 2022-07-14
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
›
⌄
WITH T1 AS (
select DISTINCT(to_address) AS WALLET, SUM(AMOUNT_USD) AS "SELL"
from flipside_prod_db.polygon.events_emitted e
inner JOIN flipside_prod_db.polygon.udm_events u on u.TX_ID=e.TX_ID
where
TX_TO_LABEL_TYPE = 'nft'
and u.FROM_ADDRESS is not NULL
and u.to_address is not null
and u.TO_LABEL_TYPE is null
and u.EVENT_TYPE = 'erc20_transfer'
and u.FROM_LABEL_TYPE is NULL
AND AMOUNT_USD IS NOT NULL
GROUP BY 1
),
T2 AS (
select DISTINCT(FROM_address) AS WALLETS, SUM(AMOUNT_USD) AS "BUY"
from flipside_prod_db.polygon.events_emitted e
inner JOIN flipside_prod_db.polygon.udm_events u on u.TX_ID=e.TX_ID
where
TX_TO_LABEL_TYPE = 'nft'
and u.FROM_ADDRESS is not NULL
and u.to_address is not null
and u.TO_LABEL_TYPE is null
and u.EVENT_TYPE = 'erc20_transfer'
and u.FROM_LABEL_TYPE is NULL
AND AMOUNT_USD IS NOT NULL
GROUP BY 1
)
SELECT DISTINCT WALLET, "SELL" ,"BUY" ,("SELL")-("BUY") AS PROFIT
FROM T1 INNER JOIN T2 ON WALLET=WALLETS
ORDER BY 4 DESC
LIMIT 5
Run a query to Download Data