TOTAL_TRADES | TOTAL_TRADERS | TOTAL_TRADED_VOLUME | AVG_TRADES_PER_USERS | AVG_TRADED_VOL_PER_USERS | |
|---|---|---|---|---|---|
1 | 25836337 | 1426227 | 9186556919.94381 | 18.115165 | 6441.160432346 |
feyikemiAptos DEX Totals
Updated 2025-03-25
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
With stats AS(
SELECT
Tx_hash,
Swapper,
COALESCE(AMOUNT_IN_USD, AMOUNT_OUT_USD) AS Volume
FROM
aptos.defi.ez_dex_swaps
WHERE BLOCK_TIMESTAMP :: DATE >= '{{Start_Date}}'
and AMOUNT_IN_USD < 1e6 and AMOUNT_OUT_USD < 1e6
)
SELECT
COUNT(DISTINCT Tx_hash) AS Total_trades,
COUNT(DISTINCT Swapper) AS Total_Traders,
SUM(Volume) AS Total_Traded_Volume,
Total_Trades / Total_Traders AS Avg_Trades_Per_Users,
Total_Traded_Volume / Total_Traders AS AVG_Traded_vol_per_Users
FROM Stats
Last run: 2 months ago
1
62B
16s