SOURCE_CHAIN_NAME | DESTINATION_CHAIN_NAME | USDT_INBOUND | USDT_OUTBOUND | BRIDGE_IDENTIFIER | |
|---|---|---|---|---|---|
1 | aptos | Polygon | 1083.08301 | aptos-Polygon bridge | |
2 | aptos | BNB | 789.2487 | aptos-bnb bridge | |
3 | aptos | celo | 168.109612 | aptos-celo bridge | |
4 | aptos | Arbitrum | 2528.22209 | aptos-Arbitrum bridge | |
5 | aptos | base | 1405.061773 | aptos-base bridge | |
6 | Aptos | BSC | 338821997.801617 | Aptos-BSC bridge | |
7 | aptos | avalanche | 41643.661616 | aptos-avalanche bridge | |
8 | aptos | bsc | 13759.333677 | other bridge | |
9 | aptos | injective | 0.1 | aptos-injective bridge | |
10 | aptos | Optimism | 350.66094 | aptos-Optimism bridge | |
11 | Aptos | Avalanche | 151648289.245278 | Aptos-Avalanche bridge | |
12 | aptos | ZkSync | 2507.86145 | aptos-zksync bridge | |
13 | aptos | Sui | 137.62926 | other bridge | |
14 | aptos | sui | 11148.234842 | aptos-sui bridge | |
15 | aptos | solana | 1979.970569 | aptos-solana bridge | |
16 | aptos | arbitrum | 1925.17889 | aptos-arbitrum bridge | |
17 | aptos | polygon | 103077.268286 | aptos-polygon bridge | |
18 | Aptos | Ethereum | 61133955.880028 | Aptos-Ethereum bridge | |
19 | aptos | optimism | 655.08744 | aptos-optimism bridge | |
20 | aptos | ethereum | 26087.21085 | aptos-ethereum bridge |
datavortexnet flow
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
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
WITH usdt_bridge AS (
SELECT
source_chain_name,
destination_chain_name,
SUM(CASE WHEN direction = 'inbound' THEN amount_unadj ELSE 0 END) / 1000000 AS usdt_inbound,
SUM(CASE WHEN direction = 'outbound' THEN amount_unadj ELSE 0 END) / 1000000 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 source_chain_name, destination_chain_name
)
SELECT
source_chain_name,
destination_chain_name,
NULLIF(usdt_inbound, 0) AS usdt_inbound,
NULLIF(usdt_outbound, 0) AS usdt_outbound,
CASE
WHEN source_chain_name = 'BSC' AND destination_chain_name = 'Aptos' THEN 'bsc-aptos bridge'
WHEN source_chain_name = 'Avalanche' AND destination_chain_name = 'Aptos' THEN 'avalanche-aptos bridge'
WHEN source_chain_name = 'Polygon' AND destination_chain_name = 'Aptos' THEN 'polygon-aptos bridge'
WHEN source_chain_name = 'Ethereum' AND destination_chain_name = 'Aptos' THEN 'ethereum-aptos bridge'
WHEN source_chain_name = 'Polygon' AND destination_chain_name = 'aptos' THEN 'polygon-aptos bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'sui' THEN 'aptos-sui bridge'
WHEN source_chain_name = 'Arbitrum' AND destination_chain_name = 'aptos' THEN 'arbitrum-aptos bridge'
WHEN source_chain_name = 'BSC' AND destination_chain_name = 'aptos' THEN 'bsc-aptos bridge'
WHEN source_chain_name = 'ZkSync' AND destination_chain_name = 'aptos' THEN 'zksync-aptos bridge'
WHEN source_chain_name = 'BNB' AND destination_chain_name = 'aptos' THEN 'bnb-aptos bridge'
WHEN source_chain_name = 'Optimism' AND destination_chain_name = 'aptos' THEN 'optimism-aptos bridge'
WHEN source_chain_name = 'Sui' AND destination_chain_name = 'aptos' THEN 'sui-aptos bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'injective' THEN 'aptos-injective bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'fantom' THEN 'aptos-fantom bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'celo' THEN 'aptos-celo bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'klaytn' THEN 'aptos-klaytn bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'BNB' THEN 'aptos-bnb bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'base' THEN 'aptos-base bridge'
WHEN source_chain_name = 'aptos' AND destination_chain_name = 'ZkSync' THEN 'aptos-zksync bridge'
Last run: 11 days ago
33
2KB
6s