CATEGORY | SWAP_PAIR | TOKEN_OUT_CONTRACT | SWAPS | VOLUME | |
---|---|---|---|---|---|
1 | NEAR | wNEAR -> USDT.e | dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near | 1472852 | 483618696.440688 |
2 | NEAR | wNEAR -> USDC.e | a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near | 654130 | 215208875.663499 |
3 | NEAR | wNEAR -> USDC | 17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1 | 756645 | 170511360.218122 |
4 | NEAR | wNEAR -> REF | token.v2.ref-finance.near | 223805 | 104439735.10387 |
5 | NEAR | wNEAR -> STNEAR | meta-pool.near | 115803 | 90333763.0480959 |
6 | USDC | USDC -> USDt | usdt.tether-token.near | 1036339 | 422210185.182513 |
7 | USDC | USDC -> wNEAR | wrap.near | 783483 | 168479606.2791 |
8 | USDC | USDC -> FRAX | 853d955acef822db058eb8505911ed77f175b99e.factory.bridge.near | 275285 | 66654856.8115499 |
9 | USDC | USDC -> USDC.e | a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near | 41951 | 26434523.2122003 |
10 | USDC | USDC -> USDT.e | dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near | 107862 | 20191577.0655922 |
11 | USDT | USDt -> USDC | 17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1 | 983376 | 417789782.823785 |
12 | USDT | USDt -> wNEAR | wrap.near | 1692601 | 71967811.5202972 |
13 | USDT | USDt -> USDT.e | dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near | 359710 | 45290539.1465368 |
14 | USDT | USDt -> USDC.e | a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near | 135334 | 16412764.6431589 |
15 | USDT | usmeme.tg | 85630 | 774522.168666239 |
datavortexStable Coin Swaps
Updated 2025-01-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
32
33
34
35
36
›
⌄
WITH usdc_swaps AS (
SELECT
'USDC' AS category,
CONCAT(symbol_in, ' -> ', symbol_out) AS swap_pair,
token_out_contract,
COUNT(DISTINCT tx_hash) AS swaps,
SUM(amount_in_usd) AS volume
FROM near.defi.ez_dex_swaps
WHERE platform = 'v2.ref-finance.near'
AND symbol_in = 'USDC'
AND amount_in_usd IS NOT NULL
GROUP BY symbol_in, symbol_out, token_out_contract
ORDER BY volume DESC, swaps DESC
LIMIT 5
),
usdt_swaps AS (
SELECT
'USDT' AS category,
CONCAT(symbol_in, ' -> ', symbol_out) AS swap_pair,
token_out_contract,
COUNT(DISTINCT tx_hash) AS swaps,
SUM(amount_in_usd) AS volume
FROM near.defi.ez_dex_swaps
WHERE platform = 'v2.ref-finance.near'
AND symbol_in = 'USDt'
AND amount_in_usd IS NOT NULL
GROUP BY symbol_in, symbol_out, token_out_contract
ORDER BY volume DESC, swaps DESC
LIMIT 5
),
near_swaps AS (
SELECT
'NEAR' AS category,
CONCAT(symbol_in, ' -> ', symbol_out) AS swap_pair,
token_out_contract,
COUNT(DISTINCT tx_hash) AS swaps,
Last run: 19 days ago
15
1KB
300s