datavortexswap pairs
Updated 2025-01-24
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
›
⌄
WITH swap_pair_activity AS (
SELECT
symbol_in,
symbol_out,
COUNT(DISTINCT tx_id) AS swap_count,
SUM(amount_in_usd) AS total_volume
FROM
sei.defi.ez_dex_swaps
WHERE
symbol_in IS NOT NULL
AND symbol_out IS NOT NULL
GROUP BY
symbol_in, symbol_out
)
SELECT
CONCAT(symbol_in, '->', symbol_out) AS swap_pair,
swap_count,
total_volume
FROM
swap_pair_activity
WHERE
total_volume IS NOT NULL
ORDER BY
swap_count DESC, total_volume DESC
LIMIT 10;
QueryRunArchived: QueryRun has been archived