yasminSWAP
    Updated 2025-05-10
    SELECT
    DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,
    COUNT(DISTINCT TX_HASH) AS "Total Transactions",
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Users",
    SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) AS "Trading Volume USD",
    SUM(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) / COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS "Avg Volume Per User",
    AVG(COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD, 0)) AS "Avg Volume"
    FROM
    avalanche.defi.ez_dex_swaps
    WHERE
    TOKEN_IN = LOWER('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')
    OR
    TOKEN_OUT = LOWER('0xb2f85b7ab3c2b6f62df06de6ae7d09c010a5096e')
    GROUP BY
    DATE_TRUNC('day', BLOCK_TIMESTAMP)
    ORDER BY
    Date DESC;










    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived