Updated 2025-04-30
    SELECT
    token_in_contract,
    symbol_in,
    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 amount_in_usd IS NOT NULL
    GROUP BY
    token_in_contract,
    symbol_in
    ORDER BY
    volume DESC,
    swaps DESC
    LIMIT
    10;
    Last run: 21 days ago
    TOKEN_IN_CONTRACT
    SYMBOL_IN
    SWAPS
    VOLUME
    1
    wrap.nearwNEAR110153851716244325.69802
    2
    17208628f84f5d6ad33f0da3bbbeb27ffcb398eac501a31bd6ad2011e36133a1USDC2429288705382796.343679
    3
    usdt.tether-token.nearUSDt3338929552927703.38438
    4
    dac17f958d2ee523a2206206994597c13d831ec7.factory.bridge.nearUSDT.e1751838197088993.398333
    5
    marmaj.tkn.nearmarmaj201139141996692.903345
    6
    token.v2.ref-finance.nearREF432675129590849.915481
    7
    853d955acef822db058eb8505911ed77f175b99e.factory.bridge.nearFRAX556254110108977.3024
    8
    a0b86991c6218b36c1d19d4a2e9eb0ce3606eb48.factory.bridge.nearUSDC.e737411102887453.141248
    9
    6b175474e89094c44da98b954eedeac495271d0f.factory.bridge.nearDAI324150102249017.8044
    10
    f5cfbc74057c610c8ef151a439252680ac68c6dc.factory.bridge.nearOCT18965195783176.6063002
    10
    800B
    592s