Platform | Traders | Volume Traded | Transactions | Maximum Single Trade | |
|---|---|---|---|---|---|
1 | pharaoh-v2 | 2863 | 257211274.76 | 160770 | 587573.98 |
2 | trader-joe-v2 | 2321 | 168296751.91 | 64712 | 149198.57 |
3 | balancer | 27 | 2422129 | 444 | 80345.19 |
4 | pangolin | 35 | 269.1 | 114 | 59.93 |
i_dan$XSGD: Platform
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
34
35
36
›
⌄
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')
AND usd_amount IS NOT NULL
)
SELECT
platform AS "Platform"
, COUNT(DISTINCT origin_from_address) AS "Traders"
, SUM(usd_amount) AS "Volume Traded"
, COUNT(tx_hash) AS "Transactions"
, MAX(usd_amount) AS "Maximum Single Trade"
FROM trade_data
GROUP BY 1
ORDER BY 3 DESC
-- XSGD - 0xb2F85b7AB3c2b6f62DF06dE6aE7D09c010a5096E
Last run: 16 days ago
4
172B
2s