WEEK | PLATFORM | Total USDT Inbound | Total USDT Outbound | Net USDT Flow | |
|---|---|---|---|---|---|
1 | 2024-01-01 00:00:00.000 | layerzero | 1831691.315057 | 1976044.204609 | -144352.889552 |
2 | 2024-01-01 00:00:00.000 | mover | 245.719371 | 205.7624 | 39.956971 |
3 | 2024-01-01 00:00:00.000 | wormhole | 518.52743 | 528.503931 | -9.976501 |
4 | 2024-01-08 00:00:00.000 | layerzero | 826357.370259 | 947824.044769 | -121466.67451 |
5 | 2024-01-08 00:00:00.000 | mover | 14.053121 | 32.5 | -18.446879 |
6 | 2024-01-08 00:00:00.000 | wormhole | 1716.519372 | 1721.78199 | -5.262618 |
7 | 2024-01-15 00:00:00.000 | layerzero | 2386629.175969 | 927419.059971 | 1459210.115998 |
8 | 2024-01-15 00:00:00.000 | mover | 15.9957 | 0.07592 | 15.91978 |
9 | 2024-01-15 00:00:00.000 | wormhole | 2140.659216 | 2172.833216 | -32.174 |
10 | 2024-01-22 00:00:00.000 | layerzero | 2888689.420734 | 1726353.870156 | 1162335.550578 |
11 | 2024-01-22 00:00:00.000 | mover | 126.957772 | 108.9093 | 18.048472 |
12 | 2024-01-22 00:00:00.000 | wormhole | 5102.961257 | 5106.729026 | -3.767769 |
13 | 2024-01-29 00:00:00.000 | layerzero | 2469737.375693 | 1006181.077311 | 1463556.298382 |
14 | 2024-01-29 00:00:00.000 | mover | 50.87994 | 0 | 50.87994 |
15 | 2024-01-29 00:00:00.000 | wormhole | 432.493578 | 404.049021 | 28.444557 |
16 | 2024-02-05 00:00:00.000 | layerzero | 2794111.532387 | 3212572.179232 | -418460.646845 |
17 | 2024-02-05 00:00:00.000 | mover | 0 | 0.1 | -0.1 |
18 | 2024-02-05 00:00:00.000 | wormhole | 257.870823 | 258.372823 | -0.502 |
19 | 2024-02-12 00:00:00.000 | layerzero | 1847038.612338 | 1471912.248948 | 375126.36339 |
20 | 2024-02-12 00:00:00.000 | mover | 0 | 345.15 | -345.15 |
datavortexWeekly Inbound Outbound USDT per Platform
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
›
⌄
WITH usdt_bridge AS (
SELECT
DATE_TRUNC('week', block_timestamp) AS week,
platform,
direction,
token_address,
SUM(CASE WHEN direction = 'inbound' THEN amount_unadj ELSE 0 END) AS usdt_received,
SUM(CASE WHEN direction = 'outbound' THEN amount_unadj ELSE 0 END) AS usdt_sent
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 week, platform, direction, token_address
)
SELECT
week,
platform,
SUM(usdt_received) / POWER(10, 6) AS "Total USDT Inbound",
SUM(usdt_sent) / POWER(10, 6) AS "Total USDT Outbound",
(SUM(usdt_received) - SUM(usdt_sent)) / POWER(10, 6) AS "Net USDT Flow"
FROM usdt_bridge
GROUP BY week, platform
ORDER BY week, platform;
Last run: 10 days ago
...
142
10KB
2s