yasminSWAP
Updated 2025-05-10
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
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