PLATFORM | USDT_VOLUME | TOTAL_VOLUME | TOKEN_CONTRIBUTION_PERCENTAGE | |
|---|---|---|---|---|
1 | sushi | 169695151.488943 | 403210981.838999 | 42.09 |
2 | liquidswap | 463504651.52841 | 2053115681.29188 | 22.58 |
3 | cetus | 247795.827774356 | 1493609.71474922 | 16.59 |
4 | hippo | 15838713.8137344 | 148732259.692206 | 10.65 |
5 | animeswap | 52173.899783858 | 683015.343248987 | 7.64 |
6 | thala | 101654785.32932 | 2682439239.57746 | 3.79 |
7 | pancake | 23280439.6648447 | 786760768.382343 | 2.96 |
8 | auxexchange | 11640.813449322 | 2176393.54399338 | 0.53 |
9 | batswap | 18453.481122983 | 6277566.62112766 | 0.29 |
10 | cellana | 117657203.256484 | 1396751576106.8 | 0.01 |
datavortexUSDT Contribution Percentage
Updated 10 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
›
⌄
WITH platform_volumes AS (
SELECT
platform,
SUM(amount_in_usd) AS total_volume,
SUM(CASE
WHEN token_in = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
OR token_out = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
THEN amount_in_usd
ELSE 0
END) AS usdt_volume
FROM
aptos.defi.ez_dex_swaps
WHERE
block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
GROUP BY
platform
)
SELECT
platform,
usdt_volume,
total_volume,
ROUND((usdt_volume / NULLIF(total_volume, 0)) * 100, 2) AS token_contribution_percentage
FROM
platform_volumes
ORDER BY
token_contribution_percentage DESC;
Last run: 10 days ago
10
510B
4s