total volume | average volume | total traders | total swaps | volume 14days | traders 14days | swaps 14days | |
|---|---|---|---|---|---|---|---|
1 | 4313267124.01747 | 166.035221077 | 1135840 | 21504010 | 29677410.5916763 | 29904 | 529006 |
datavortexTotals
Updated 2025-04-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
SELECT
SUM(amount_in_usd) AS "total volume",
AVG(amount_in_usd) AS "average volume",
COUNT(DISTINCT trader) AS "total traders",
COUNT(DISTINCT tx_hash) AS "total swaps",
SUM(
CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '14 days' THEN amount_in_usd
ELSE 0
END
) AS "volume 14days",
COUNT(
DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '14 days' THEN trader
ELSE NULL
END
) AS "traders 14days",
COUNT(
DISTINCT CASE
WHEN block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '14 days' THEN tx_hash
ELSE NULL
END
) AS "swaps 14days"
FROM
near.defi.ez_dex_swaps
WHERE
platform = 'v2.ref-finance.near'
Last run: about 1 month ago
1
81B
533s