DATE | Total Transactions | Users | Trading Volume USD | Avg Volume Per User | Avg Volume | |
|---|---|---|---|---|---|---|
1 | 2025-04-27 00:00:00.000 | 140 | 96 | 23298.25 | 242.690104167 | 99.99248927 |
2 | 2025-04-26 00:00:00.000 | 908 | 403 | 348703.61 | 865.269503722 | 168.863733656 |
3 | 2025-04-25 00:00:00.000 | 3273 | 893 | 995504.53 | 1114.786707727 | 155.37763852 |
4 | 2025-04-24 00:00:00.000 | 5577 | 2079 | 1880483.93 | 904.513674844 | 206.374443591 |
5 | 2025-04-23 00:00:00.000 | 5994 | 2639 | 7192527.18 | 2725.474490337 | 1124.535206379 |
Updated 1 day ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
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('0xACC95Afa65768aa74044E6f6e267AD6417CD3e55')
OR
TOKEN_OUT = LOWER('0xACC95Afa65768aa74044E6f6e267AD6417CD3e55')
GROUP BY
DATE_TRUNC('DAY', BLOCK_TIMESTAMP)
ORDER BY
Date DESC;
Last run: 1 day ago
5
376B
2s