datavortexUSDT Retention Per Platform
Updated 2024-12-21
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;
QueryRunArchived: QueryRun has been archived