TOKEN_NAME | TOKEN | SWAPS | SWAPPERS | VOLUME_USD | AVERAGE_AMOUNT_USD | DAILY_AVERAGE_SWAPS | DAILY_AVERAGE_SWAPPERS | |
---|---|---|---|---|---|---|---|---|
1 | USDC (layerzero) | 0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asse... | 11156409 | 644079 | 3178030849.30829 | 205.799397224 | 33502.72973 | 1934.171171 |
2 | USDT | 0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T | 345726 | 44832 | 51278041.5402435 | 70.704829898 | 1038.216216 | 134.630631 |
3 | ceUSDC | 0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::cele... | 163228 | 17323 | 4394905.31984551 | 13.938495878 | 490.174174 | 52.021021 |
crypto_gostxenacious-tan
Updated 2024-11-29
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
28
29
30
31
32
33
34
35
36
›
⌄
WITH stablecoin AS (
SELECT
tx_hash,
block_timestamp,
swapper,
TOKEN_IN AS token,
TOKEN_OUT AS other_token,
amount_out_usd AS amount_usd,
platform
FROM
aptos.defi.ez_dex_swaps
WHERE
TOKEN_IN IN (
'0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin', -- ceUSDC
'0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T', -- USDT
'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' -- USDC ()
)
UNION ALL
SELECT
tx_hash,
block_timestamp,
swapper,
TOKEN_OUT AS token,
TOKEN_IN AS other_token,
amount_in_usd AS amount_usd,
platform
FROM
aptos.defi.ez_dex_swaps
WHERE
TOKEN_OUT IN (
'0x8d87a65ba30e09357fa2edea2c80dbac296e5dec2b18287113500b902942929d::celer_coin_manager::UsdcCoin', -- ceUSDC
'0xa2eda21a58856fda86451436513b867c97eecb4ba099da5775520e0f7492e852::coin::T', -- USDT
'0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDC' -- USDC ()
)
)
Last run: 3 months ago
3
502B
8s