DATE | TRADING_PAIR_GROUP | SWAP_VOLUME | SWAPS | SWAPPERS | |
|---|---|---|---|---|---|
1 | 2025-01-23 00:00:00.000 | Others | 5115373.32688879 | 32244 | 8121 |
2 | 2025-01-23 00:00:00.000 | APT -> USDC | 3326947.4766036 | 13036 | 1238 |
3 | 2025-01-23 00:00:00.000 | USDC -> APT | 3154978.87310141 | 12374 | 1530 |
4 | 2025-01-23 00:00:00.000 | APT -> USDT | 767472.605630333 | 5328 | 535 |
5 | 2025-01-23 00:00:00.000 | USDT -> APT | 721621.97088706 | 5028 | 604 |
6 | 2025-01-23 00:00:00.000 | APT -> Unknown | 71678.845308257 | 3856 | 612 |
7 | 2025-01-24 00:00:00.000 | Others | 6878847.40157984 | 25690 | 7557 |
8 | 2025-01-24 00:00:00.000 | APT -> USDC | 2308256.31613553 | 10404 | 1263 |
9 | 2025-01-24 00:00:00.000 | USDC -> APT | 2106166.61090477 | 8723 | 1280 |
10 | 2025-01-24 00:00:00.000 | APT -> USDT | 553473.045813517 | 4367 | 583 |
11 | 2025-01-24 00:00:00.000 | USDT -> APT | 503500.143611823 | 3472 | 610 |
12 | 2025-01-24 00:00:00.000 | APT -> Unknown | 75976.946194699 | 3358 | 541 |
13 | 2025-01-25 00:00:00.000 | Others | 1871534.95137353 | 16658 | 6700 |
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 | APT -> Unknown | 42740.497594151 | 2992 | 368 |
17 | 2025-01-25 00:00:00.000 | Unknown -> APT | 46260.818779449 | 2791 | 418 |
18 | 2025-01-25 00:00:00.000 | APT -> USDT | 253656.728554036 | 2561 | 421 |
19 | 2025-01-26 00:00:00.000 | Others | 1984052.43095072 | 15982 | 5596 |
20 | 2025-01-26 00:00:00.000 | APT -> USDC | 1213978.27251201 | 7598 | 866 |
zyroqapt dex p1 swaps
Updated 4 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
›
⌄
-- forked from apt dex p1 swap vol @ https://flipsidecrypto.xyz/studio/queries/4daad9f1-0a39-44b8-a301-a1198a325f4b
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,
Last run: 4 days ago
...
546
37KB
5s