CHAIN | NUMBER_OF_USERS | VOLUME | |
|---|---|---|---|
1 | Ethereum | 4233 | 869093293.39 |
2 | Avalanche | 3592 | 426710435.56 |
3 | Polygon | 22315 | 396576982.27 |
permarydex swaps volume
Updated 2025-03-16
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
›
⌄
-- Multi-Chain XSGD User Count & Volume
WITH xsgd_users_volume AS (
SELECT
'Ethereum' AS chain,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(amount_in_usd) AS volume
FROM ethereum.defi.ez_dex_swaps
WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
UNION ALL
SELECT
'Polygon' AS chain,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(amount_in_usd) AS volume
FROM polygon.defi.ez_dex_swaps
WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
UNION ALL
SELECT
'Avalanche' AS chain,
COUNT(DISTINCT origin_from_address) AS number_of_users,
SUM(amount_in_usd) AS volume
FROM avalanche.defi.ez_dex_swaps
WHERE (SYMBOL_IN = 'XSGD' OR SYMBOL_OUT = 'XSGD')
)
SELECT * FROM xsgd_users_volume
ORDER BY volume DESC;
Last run: about 1 month ago
3
95B
13s