datavortexTop Swap Routes
    Updated 2025-05-07
    SELECT
    from_asset,
    to_asset,

    SUM(from_amount_usd) AS TotalVolumeUSD,

    CASE
    WHEN SUM(from_amount_usd) >= 1000000000 THEN
    TO_CHAR(ROUND(SUM(from_amount_usd) / 1000000000, 2)) || 'B'
    WHEN SUM(from_amount_usd) >= 1000000 THEN
    TO_CHAR(ROUND(SUM(from_amount_usd) / 1000000, 2)) || 'M'
    WHEN SUM(from_amount_usd) >= 1000 THEN
    TO_CHAR(ROUND(SUM(from_amount_usd) / 1000, 2)) || 'K'
    ELSE
    TO_CHAR(SUM(from_amount_usd))
    END AS TotalVolume2,


    COUNT(DISTINCT tx_id) AS TotalTransactions,

    CASE
    WHEN COUNT(DISTINCT tx_id) >= 1000000 THEN
    TO_CHAR(ROUND(COUNT(DISTINCT tx_id) / 1000000, 2)) || 'M'
    WHEN COUNT(DISTINCT tx_id) >= 1000 THEN
    TO_CHAR(ROUND(COUNT(DISTINCT tx_id) / 1000, 2)) || 'K'
    ELSE
    TO_CHAR(COUNT(DISTINCT tx_id))
    END AS TotalTransactions2,


    COUNT(DISTINCT from_address) AS ActiveSwappers,

    CASE
    WHEN COUNT(DISTINCT from_address) >= 1000000 THEN
    TO_CHAR(ROUND(COUNT(DISTINCT from_address) / 1000000, 2)) || 'M'
    WHEN COUNT(DISTINCT from_address) >= 1000 THEN
    Last run: 17 days ago
    FROM_ASSET
    TO_ASSET
    TOTALVOLUMEUSD
    TOTALVOLUME2
    TOTALTRANSACTIONS
    TOTALTRANSACTIONS2
    ACTIVESWAPPERS
    ACTIVESWAPPERS2
    1
    BTC/BTCTHOR.RUNE7109160383.339677.11B15463351.55M28302.83K
    2
    THOR.RUNEBTC/BTC7094519208.074037.09B19116551.91M48184.82K
    3
    BTC.BTCTHOR.RUNE6048828470.28246.05B489491489.49K226863226.86K
    4
    THOR.RUNEBTC~BTC5870648969.086785.87B863057863.06K8282
    4
    313B
    26s