datavortexweekly
Updated 2025-01-15
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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