Updated 2025-01-15
    SELECT
    date_trunc('week', block_timestamp) AS week,
    SUM(amount_in_usd) AS "total volume",
    -- AVG(amount_in_usd) AS "average volume",
    COUNT(DISTINCT trader) AS "total traders",
    FROM
    near.defi.ez_dex_swaps
    WHERE
    platform = 'v2.ref-finance.near'
    GROUP BY week
    ORDER BY week;
    QueryRunArchived: QueryRun has been archived