TOKEN_SYMBOL | TOKEN_IN | VOLUME | UNIQUE_SWAPPERS | TOTAL_SWAPS | |
|---|---|---|---|---|---|
1 | APT | 0x1::aptos_coin::AptosCoin | 30027693.1327354 | 26047 | 501093 |
2 | lzUSDC | 0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asse... | 9200022.08203489 | 4686 | 125309 |
3 | USDt | 0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b | 5589345.18843166 | 2622 | 256310 |
4 | USDC | 0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b | 4790498.57531235 | 2901 | 253666 |
5 | lzUSDT | 0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asse... | 2847164.48768881 | 2418 | 65966 |
6 | Unknown | 0xb36527754eb54d7ff55daf13bcb54b42b88ec484bd6f0e3b2e0d1db169de6451 | 2526549.49391778 | 8517 | 21158 |
7 | amAPT | 0x111ae3e5bc816a5e63c2da97d0aa3886519e0cd5e4b046659fa35796bd11542a::amap... | 2154909.25664999 | 2553 | 13167 |
8 | MOD | 0x6f986d146e4a90b828d8c12c14b6f4e003fdff11a8eecceceb63744363eaac01::mod_... | 1686921.94743635 | 622 | 10790 |
9 | USDC | 0x5e156f1207d0ebfa19a9eeff00d62a282278fb8719f4fab3a586a0a2c0fffbea::coin::T | 1416709.65939468 | 975 | 44385 |
10 | thAPT | 0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::stak... | 1398563.59494661 | 802 | 3326 |
zyroq16
Updated 10 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
SELECT
CASE
WHEN TOKEN_IN = '0x357b0b74bc833e95a115ad22604854d6b0fca151cecd94111770e5d6ffc9dc2b' THEN 'USDt'
WHEN TOKEN_IN = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' THEN 'lzUSDC'
WHEN TOKEN_IN = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT' THEN 'lzUSDT'
WHEN TOKEN_IN = '0xbae207659db88bea0cbead6da0ed00aac12edcdda169e591cd41c94180b46f3b' THEN 'USDC'
ELSE COALESCE(SYMBOL_IN, 'Unknown')
END AS token_symbol,
TOKEN_IN,
SUM(COALESCE(amount_in_usd, amount_out_usd, 0)) AS volume,
COUNT(DISTINCT swapper) AS unique_swappers,
COUNT(tx_hash) AS total_swaps
FROM aptos.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(DAY, -7, CURRENT_DATE) -- Last 7 days
GROUP BY
token_symbol, TOKEN_IN
ORDER BY
volume DESC
limit 10
Last run: 10 days ago
10
1KB
2s