PLATFORM | USDT Inbound | USDT Outbound | USDT Retention Percentage | |
|---|---|---|---|---|
1 | layerzero | 658269118.316862 | 643562017.455216 | 2.23 |
2 | mover | 7481.563848 | 7396.70545 | 1.13 |
3 | wormhole | 202694.296652 | 202899.217555 | -0.1 |
datavortexUSDT Retention Per Platform
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
›
⌄
WITH usdt_bridge AS (
SELECT
platform,
SUM(CASE WHEN direction = 'inbound' THEN amount_unadj ELSE 0 END) AS usdt_inbound,
SUM(CASE WHEN direction = 'outbound' THEN amount_unadj ELSE 0 END) AS usdt_outbound
FROM aptos.defi.fact_bridge_activity
WHERE
token_address = '0xf22bede237a07e121b56d91a491eb7bcdfd1f5907926a9e58338f964a01b17fa::asset::USDT'
AND block_timestamp BETWEEN '2024-01-01' AND '2024-12-31'
GROUP BY platform
)
SELECT
platform,
usdt_inbound / POWER(10, 6) AS "USDT Inbound",
usdt_outbound / POWER(10, 6) AS "USDT Outbound",
ROUND(
(NULLIF(usdt_inbound - usdt_outbound, 0) / NULLIF(usdt_inbound, 0)) * 100,
2
) AS "USDT Retention Percentage"
FROM usdt_bridge
WHERE usdt_inbound > 0
ORDER BY platform;
Last run: 10 days ago
3
138B
5s