DATE | TRADING_PAIR_GROUP | SWAP_VOLUME | SWAPS | SWAPPERS | |
|---|---|---|---|---|---|
1 | 2025-02-11 00:00:00.000 | APT -> USDC | 2393386.67137508 | 11332 | 2540 |
2 | 2025-02-11 00:00:00.000 | USDC -> APT | 1996050.82201854 | 8421 | 1727 |
3 | 2025-02-11 00:00:00.000 | Others | 1807812.55848844 | 27870 | 9660 |
4 | 2025-02-11 00:00:00.000 | APT -> amAPT | 736413.983222593 | 872 | 531 |
5 | 2025-02-11 00:00:00.000 | amAPT -> APT | 617979.046683691 | 1101 | 528 |
6 | 2025-02-11 00:00:00.000 | APT -> USDT | 500141.53426474 | 3695 | 690 |
7 | 2025-02-12 00:00:00.000 | USDC -> APT | 3038340.21117491 | 11699 | 1206 |
8 | 2025-02-12 00:00:00.000 | APT -> USDC | 2702893.49076503 | 12016 | 1229 |
9 | 2025-02-12 00:00:00.000 | Others | 1967671.93720999 | 33066 | 11584 |
10 | 2025-02-12 00:00:00.000 | USDT -> APT | 647733.969716629 | 4055 | 634 |
11 | 2025-02-12 00:00:00.000 | APT -> USDT | 573218.39437282 | 4302 | 542 |
12 | 2025-02-12 00:00:00.000 | aBTC -> APT | 366843.266785897 | 645 | 154 |
13 | 2025-02-13 00:00:00.000 | APT -> USDC | 1980465.97230556 | 10087 | 1659 |
14 | 2025-02-13 00:00:00.000 | Others | 1977708.17083615 | 31456 | 11254 |
15 | 2025-02-13 00:00:00.000 | USDC -> APT | 1946325.32347808 | 9443 | 1697 |
16 | 2025-02-13 00:00:00.000 | APT -> amAPT | 769012.938823674 | 994 | 524 |
17 | 2025-02-13 00:00:00.000 | amAPT -> APT | 666362.914711635 | 2740 | 1873 |
18 | 2025-02-13 00:00:00.000 | APT -> USDT | 416755.794869475 | 3634 | 734 |
19 | 2025-02-14 00:00:00.000 | APT -> USDC | 1588495.88472847 | 11748 | 2261 |
20 | 2025-02-14 00:00:00.000 | USDC -> APT | 1541390.24607967 | 10073 | 2130 |
zyroqapt dex p1 swap vol
Updated 2025-05-12
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: 16 days ago
...
546
36KB
8s