TOKEN_SWAPPED_IN | TOTAL_SWAP_VOLUME | TOTAL_SWAPPERS | |
---|---|---|---|
1 | WAVAX | 14669143.73 | 3259 |
2 | abcPHAR | 4176289.52 | 544 |
3 | USDC | 1855456.06 | 1107 |
4 | USDt | 1107395.49 | 979 |
5 | WETH.e | 5828.98 | 10 |
6 | KET | 4532.42 | 200 |
7 | AUSD | 2201.94 | 3 |
gigiokobaearly-harlequin
Updated 2025-02-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH swap_data AS (
SELECT
SYMBOL_IN AS token_swapped_in,
AMOUNT_IN_USD AS swap_volume,
ORIGIN_FROM_ADDRESS AS swapper_address
FROM
avalanche.defi.ez_dex_swaps
WHERE
TOKEN_OUT = '0xaaab9d12a30504559b0c5a9a5977fee4a6081c6b' -- Token being swapped to
)
SELECT
token_swapped_in,
SUM(swap_volume) AS total_swap_volume,
COUNT(DISTINCT swapper_address) AS total_swappers
FROM
swap_data
WHERE swap_volume IS NOT NULL
GROUP BY
token_swapped_in
ORDER BY
total_swap_volume DESC;
Last run: 14 days ago
7
165B
3s