i_dan$TRUMP: Top Gainers
Updated 2025-02-01
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
›
⌄
WITH net AS (
SELECT
swapper
, SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_from_amount_usd ELSE 0 END) AS buy
, SUM(CASE WHEN swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_to_amount_usd ELSE 0 END) AS sell
, sell - buy AS profit
, CASE WHEN buy = 0 THEN '0' ELSE (sell / buy) * 100 END AS change
, buy + sell AS Volume
-- , SUM(CASE WHEN swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_to_amount ELSE 0 END) AS bought
-- , SUM(CASE WHEN swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN' THEN swap_from_amount ELSE 0 END) AS sold
FROM solana.defi.ez_dex_swaps
WHERE swap_to_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
OR swap_from_mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'
GROUP BY 1
HAVING sell IS NOT NULL
AND buy IS NOT NULL
-- AND bought >= sold
ORDER BY profit DESC
LIMIT 100
)
SELECT
swapper AS "Trader"
, '💲'||TO_CHAR(buy, '999,999,999,999,999,999') AS "Bought"
, '💲'||TO_CHAR(sell, '999,999,999,999,999,999') AS "Sold"
, '💲'||TO_CHAR(profit, '999,999,999,999,999,999') AS "Net Profit"
, ROUND(change ,2)||'%' AS "Profit Change"
, '💲'||TO_CHAR(Volume, '999,999,999,999,999,999') AS "Trader Volume"
FROM net
QueryRunArchived: QueryRun has been archived