datavortexvs other dex
    Updated 2025-04-23
    SELECT
    project,
    COUNT(DISTINCT tx_hash) AS "total swaps",
    COUNT(DISTINCT pool_address) AS "total pools",
    COUNT(DISTINCT trader_address) AS "total traders",
    SUM(volume_ton) AS "total swap volume (TON)",
    SUM(volume_usd) AS "total swap volume (USD)",
    AVG(volume_usd) AS "avg swap volume (USD)",
    COUNT(DISTINCT tx_hash) * 1.0 / NULLIF(COUNT(DISTINCT trader_address), 0) AS "avg swaps per trader",
    SUM(volume_usd) / NULLIF(COUNT(DISTINCT pool_address), 0) AS "avg swap volume per pool (USD)"
    FROM
    ton.defi.fact_dex_trades
    WHERE
    volume_usd IS NOT NULL
    GROUP BY
    project
    ORDER BY
    "total swap volume (USD)" DESC;
    Last run: about 2 months ago
    PROJECT
    total swaps
    total pools
    total traders
    total swap volume (TON)
    total swap volume (USD)
    avg swap volume (USD)
    avg swaps per trader
    avg swap volume per pool (USD)
    1
    ston.fi2415757322381499407810756040905845086829241.9567084.837244261162.898396
    2
    dedust113948033421512541708493322354824152730423.3642949.085533140995.257343
    3
    ton.fun47824723967116182576570165929674242962.0479187.735411748.006556
    4
    tonco751421005774426106681623631652160.75117813.0138551623631.65
    5
    gaspump764646255854326873817014318904656.48240617.6723211688.061208
    6
    megaton8037286106355362752263342.44904813.1754198295.107143
    6
    493B
    6s