TRADING_YEAR | YEARLY_VOLUME | PREVIOUS_YEAR_VOLUME | VOLUME_CHANGE_PERCENTAGE | TOTAL_SWAPPERS | PREVIOUS_YEAR_SWAPPERS | SWAPPERS_CHANGE_PERCENTAGE | TOTAL_SWAPS | PREVIOUS_YEAR_SWAPS | SWAPS_CHANGE_PERCENTAGE | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | 891961009.103867 | 49936412.923278 | 1686.193594791 | 383480 | 328763 | 16.6433 | 4038961 | 2759520 | 46.3646 |
datavortexAVereages
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 yearly_metrics AS (
SELECT
DATE_TRUNC('year', block_timestamp) AS trading_year,
SUM(amount_in_usd) AS yearly_volume,
COUNT(DISTINCT swapper) AS total_swappers,
COUNT(DISTINCT tx_hash) AS total_swaps
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2023-01-01' AND '2024-12-31'
AND (token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT')
GROUP BY
trading_year
),
yearly_change AS (
SELECT
curr.trading_year,
curr.yearly_volume,
LAG(curr.yearly_volume) OVER (ORDER BY curr.trading_year) AS previous_year_volume,
curr.total_swappers,
LAG(curr.total_swappers) OVER (ORDER BY curr.trading_year) AS previous_year_swappers,
curr.total_swaps,
LAG(curr.total_swaps) OVER (ORDER BY curr.trading_year) AS previous_year_swaps
FROM
yearly_metrics curr
)
SELECT
trading_year,
yearly_volume,
previous_year_volume,
CASE
WHEN previous_year_volume IS NOT NULL THEN
((yearly_volume - previous_year_volume) / previous_year_volume) * 100
ELSE NULL
Last run: about 1 month ago
1
123B
11s