DATE | TRADING_PAIR_GROUP | SWAP_VOLUME | SWAPS | SWAPPERS | |
|---|---|---|---|---|---|
1 | 2025-01-23 00:00:00.000 | APT -> USDC | 3326947.4766036 | 13036 | 1238 |
2 | 2025-01-23 00:00:00.000 | USDC -> APT | 3154978.87310141 | 12374 | 1530 |
3 | 2025-01-23 00:00:00.000 | Others | 2313418.58709426 | 37674 | 8480 |
4 | 2025-01-23 00:00:00.000 | APT -> amAPT | 1903912.32895794 | 1669 | 339 |
5 | 2025-01-23 00:00:00.000 | amAPT -> APT | 1691343.2270319 | 1785 | 518 |
6 | 2025-01-23 00:00:00.000 | APT -> USDT | 767472.605630333 | 5328 | 535 |
7 | 2025-01-24 00:00:00.000 | amAPT -> APT | 2894720.64588433 | 1126 | 391 |
8 | 2025-01-24 00:00:00.000 | APT -> amAPT | 2482266.79874277 | 1028 | 280 |
9 | 2025-01-24 00:00:00.000 | APT -> USDC | 2308256.31613553 | 10404 | 1263 |
10 | 2025-01-24 00:00:00.000 | USDC -> APT | 2106166.61090477 | 8723 | 1280 |
11 | 2025-01-24 00:00:00.000 | Others | 2081337.04675926 | 30366 | 8037 |
12 | 2025-01-24 00:00:00.000 | APT -> USDT | 553473.045813517 | 4367 | 583 |
13 | 2025-01-25 00:00:00.000 | Others | 1366099.71010672 | 23326 | 7100 |
14 | 2025-01-25 00:00:00.000 | APT -> USDC | 1075204.73010541 | 5870 | 940 |
15 | 2025-01-25 00:00:00.000 | USDC -> APT | 942523.326453056 | 5382 | 990 |
16 | 2025-01-25 00:00:00.000 | amAPT -> APT | 287529.701975754 | 965 | 552 |
17 | 2025-01-25 00:00:00.000 | APT -> amAPT | 286902.579596426 | 376 | 195 |
18 | 2025-01-25 00:00:00.000 | thAPT -> APT | 273661.004622266 | 335 | 60 |
19 | 2025-01-26 00:00:00.000 | Others | 1223124.31639378 | 21353 | 6125 |
20 | 2025-01-26 00:00:00.000 | APT -> USDC | 1213978.27251201 | 7598 | 866 |
zyroqapt dex p1 swap vol
Updated 3 days ago
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 data AS (
SELECT
block_timestamp,
DATE_TRUNC('{{granularity}}', BLOCK_TIMESTAMP) AS date,
tx_hash,
platform,
swapper,
COALESCE(NULLIF(symbol_in, ''), 'Unknown') AS symbol_in,
COALESCE(NULLIF(symbol_out, ''), 'Unknown') AS symbol_out,
COALESCE(amount_in_usd, amount_out_usd) AS amount
FROM
aptos.defi.ez_dex_swaps
WHERE
token_in = '0x1::aptos_coin::AptosCoin'
OR
token_out = '0x1::aptos_coin::AptosCoin'
),
trading_pairs AS (
SELECT
date,
symbol_in || ' -> ' || symbol_out AS trading_pair,
SUM(amount) AS swap_volume,
COUNT(DISTINCT tx_hash) AS swaps,
COUNT(DISTINCT swapper) AS swappers
FROM
data
WHERE block_timestamp > CURRENT_DATE - INTERVAL '{{trading_period}} days'
GROUP BY
date, trading_pair
),
ranked_pairs AS (
SELECT
date,
trading_pair,
swap_volume,
Last run: 3 days ago
...
546
37KB
7s