datavortexStable Coin Swaps
    Updated 2025-01-16
    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
    CATEGORY
    SWAP_PAIR
    TOKEN_OUT_CONTRACT
    SWAPS
    VOLUME
    1
    NEARwNEAR -> USDT.edac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near1472852483618696.440688
    2
    NEARwNEAR -> USDC.ea0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near654130215208875.663499
    3
    NEARwNEAR -> USDC17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1756645170511360.218122
    4
    NEARwNEAR -> REFtoken.v2.ref-finance.near223805104439735.10387
    5
    NEARwNEAR -> STNEARmeta-pool.near11580390333763.0480959
    6
    USDCUSDC -> USDtusdt.tether-token.near1036339422210185.182513
    7
    USDCUSDC -> wNEARwrap.near783483168479606.2791
    8
    USDCUSDC -> FRAX853d955acef822db058eb8505911ed77f175b99e.factory.bridge.near27528566654856.8115499
    9
    USDCUSDC -> USDC.ea0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near4195126434523.2122003
    10
    USDCUSDC -> USDT.edac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near10786220191577.0655922
    11
    USDTUSDt -> USDC17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1983376417789782.823785
    12
    USDTUSDt -> wNEARwrap.near169260171967811.5202972
    13
    USDTUSDt -> USDT.edac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.near35971045290539.1465368
    14
    USDTUSDt -> USDC.ea0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.near13533416412764.6431589
    15
    USDTusmeme.tg85630774522.168666239
    15
    1KB
    300s