i_dan$XSGD: Top Traders By Volume
Updated 2025-03-17
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
›
⌄
WITH trade_data AS (
SELECT
block_timestamp
, tx_hash
, origin_from_address
, CASE WHEN token_in = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN 'buy'
WHEN token_out = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN 'sell'
END AS Action
, CASE WHEN token_in = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN symbol_in
WHEN token_out = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN symbol_out
END AS symbol
, CASE WHEN amount_in_usd IS NULL THEN amount_out_usd ELSE amount_in_usd END AS usd_amount
, CASE WHEN token_in = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN amount_in
WHEN token_out = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E') THEN amount_out
END AS token_amount
, platform
FROM avalanche.defi.ez_dex_swaps
WHERE token_in = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
OR token_out = lower('0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E')
)
SELECT
origin_from_address AS "Address"
, SUM(usd_amount) AS "Volume Traded"
FROM trade_data
GROUP BY 1
ORDER BY 2 DESC
LIMIT 20
-- XSGD - 0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E
QueryRunArchived: QueryRun has been archived