PLATFORM | WEEK | UNIQUE_SWAPPERS | PREVIOUS_WEEK_SWAPPERS | GROWTH_RATE | |
|---|---|---|---|---|---|
1 | animeswap | 2024-01-01 00:00:00.000 | 578 | ||
2 | animeswap | 2024-01-08 00:00:00.000 | 695 | 578 | 20.24 |
3 | animeswap | 2024-01-15 00:00:00.000 | 346 | 695 | -50.22 |
4 | animeswap | 2024-01-22 00:00:00.000 | 367 | 346 | 6.07 |
5 | animeswap | 2024-01-29 00:00:00.000 | 365 | 367 | -0.55 |
6 | animeswap | 2024-02-05 00:00:00.000 | 458 | 365 | 25.48 |
7 | animeswap | 2024-02-12 00:00:00.000 | 490 | 458 | 6.99 |
8 | animeswap | 2024-02-19 00:00:00.000 | 436 | 490 | -11.02 |
9 | animeswap | 2024-02-26 00:00:00.000 | 406 | 436 | -6.88 |
10 | animeswap | 2024-03-04 00:00:00.000 | 353 | 406 | -13.05 |
11 | animeswap | 2024-03-11 00:00:00.000 | 468 | 353 | 32.58 |
12 | animeswap | 2024-03-18 00:00:00.000 | 507 | 468 | 8.33 |
13 | animeswap | 2024-03-25 00:00:00.000 | 203 | 507 | -59.96 |
14 | animeswap | 2024-04-01 00:00:00.000 | 209 | 203 | 2.96 |
15 | animeswap | 2024-04-08 00:00:00.000 | 263 | 209 | 25.84 |
16 | animeswap | 2024-04-15 00:00:00.000 | 397 | 263 | 50.95 |
17 | animeswap | 2024-04-22 00:00:00.000 | 163 | 397 | -58.94 |
18 | animeswap | 2024-04-29 00:00:00.000 | 218 | 163 | 33.74 |
19 | animeswap | 2024-05-06 00:00:00.000 | 185 | 218 | -15.14 |
20 | animeswap | 2024-05-13 00:00:00.000 | 119 | 185 | -35.68 |
datavortexWeekly Swappers Per PLatform and Growth Rate
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
›
⌄
WITH weekly_swappers AS (
SELECT
platform,
DATE_TRUNC('week', block_timestamp) AS week,
COUNT(DISTINCT swapper) AS unique_swappers
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp >= '2024-01-01'
AND block_timestamp < '2025-01-01'
AND (token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT')
GROUP BY
platform, week
)
SELECT
platform,
week,
unique_swappers,
LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week) AS previous_week_swappers,
ROUND((unique_swappers - COALESCE(LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week), 0)) / NULLIF(LAG(unique_swappers) OVER (PARTITION BY platform ORDER BY week), 0) * 100, 2) AS growth_rate
FROM
weekly_swappers
ORDER BY
platform, week;
Last run: 11 days ago
...
522
27KB
3s