TOTAL_VOLUME | WEEK | WEEKLY_VOLUME | WEEKLY_VOLUME_CHANGE_PERCENTAGE | PLATFORM | PLATFORM_VOLUME | PLATFORM_SHARE_PERCENTAGE | AVG_SWAP_VOLUME | |
|---|---|---|---|---|---|---|---|---|
1 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | dragonswap | 1813427742.31063 | 56.336470968 | 338.716220662 |
2 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | sailorswap | 777144791.097092 | 24.143004951 | 338.716220662 |
3 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | jellyswap | 354107840.854418 | 11.000816647 | 338.716220662 |
4 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | astroport | 274033294.872469 | 8.513197632 | 338.716220662 |
5 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | fuzio | 126425.133317878 | 0.003927559773 | 338.716220662 |
6 | 3218923214.68283 | 2025-05-12 00:00:00.000 | 121114520.615762 | -5.027798007 | seaswap | 83120.414901751 | 0.002582242861 | 338.716220662 |
7 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | dragonswap | 1813427742.31063 | 56.336470968 | 338.716220662 |
8 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | sailorswap | 777144791.097092 | 24.143004951 | 338.716220662 |
9 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | jellyswap | 354107840.854418 | 11.000816647 | 338.716220662 |
10 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | astroport | 274033294.872469 | 8.513197632 | 338.716220662 |
11 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | fuzio | 126425.133317878 | 0.003927559773 | 338.716220662 |
12 | 3218923214.68283 | 2025-05-05 00:00:00.000 | 127526284.612316 | 15.816528832 | seaswap | 83120.414901751 | 0.002582242861 | 338.716220662 |
13 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | dragonswap | 1813427742.31063 | 56.336470968 | 338.716220662 |
14 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | sailorswap | 777144791.097092 | 24.143004951 | 338.716220662 |
15 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | jellyswap | 354107840.854418 | 11.000816647 | 338.716220662 |
16 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | astroport | 274033294.872469 | 8.513197632 | 338.716220662 |
17 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | fuzio | 126425.133317878 | 0.003927559773 | 338.716220662 |
18 | 3218923214.68283 | 2025-04-28 00:00:00.000 | 110110608.475613 | -10.460079279 | seaswap | 83120.414901751 | 0.002582242861 | 338.716220662 |
19 | 3218923214.68283 | 2025-04-21 00:00:00.000 | 122973761.411369 | 33.912741701 | dragonswap | 1813427742.31063 | 56.336470968 | 338.716220662 |
20 | 3218923214.68283 | 2025-04-21 00:00:00.000 | 122973761.411369 | 33.912741701 | sailorswap | 777144791.097092 | 24.143004951 | 338.716220662 |
datavortexvolume change
Updated 2025-05-18
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 volume_activity AS (
SELECT
SUM(amount_in_usd) AS total_volume
FROM
sei.defi.ez_dex_swaps
),
weekly_volume AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
SUM(amount_in_usd) AS weekly_volume
FROM
sei.defi.ez_dex_swaps
GROUP BY
week
),
weekly_volume_change_last_7d AS (
SELECT
SUM(amount_in_usd) AS volume_change_last_7d
FROM
sei.defi.ez_dex_swaps
WHERE
block_timestamp >= CURRENT_DATE - INTERVAL '7 DAY'
),
weekly_volume_change_percentage AS (
SELECT
(wv.weekly_volume - LAG(wv.weekly_volume) OVER (ORDER BY wv.week)) * 1.0 / LAG(wv.weekly_volume) OVER (ORDER BY wv.week) * 100 AS weekly_volume_change_percentage,
wv.week,
wv.weekly_volume
FROM
weekly_volume wv
),
platform_volume_share AS (
SELECT
platform,
SUM(amount_in_usd) AS platform_volume,
(SUM(amount_in_usd) * 1.0 / (SELECT SUM(amount_in_usd) FROM sei.defi.ez_dex_swaps)) * 100 AS platform_share_percentage
Last run: 26 days ago
...
552
70KB
4s