symbol | total_volume_in_usd | average_daily_swap_volume_in_usd | |
|---|---|---|---|
1 | USDC | 53506610.9188618 | 1783553.69729539 |
2 | SOL | 31897763.8914809 | 1063258.7963827 |
3 | ETH | 29890564.2169623 | 996352.140565411 |
4 | WBTC | 21236568.3409287 | 707885.61136429 |
5 | USDCET | 11134880.4893873 | 371162.682979576 |
6 | USDTET | 6099787.36443 | 203326.245481 |
7 | USDT | 1923318.828319 | 64110.627610633 |
8 | SPX | 1495290.97008138 | 49843.032336046 |
9 | TRUMP | 1055731.10443647 | 35191.036814549 |
10 | JITOSOL | 1024233.36428654 | 34141.112142885 |
datavortexTop Bridged Tokens
Updated 2025-03-25
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 total_bridged AS (
SELECT
mint AS "bridged_token",
SUM(amount) AS "bridged_amount",
direction
FROM
solana.defi.fact_bridge_activity
WHERE
block_timestamp BETWEEN '2024-09-01' AND '2024-09-30'
GROUP BY
mint, direction
),
prices AS (
SELECT
token_address AS "token_address",
symbol AS "symbol",
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY price) AS "median_price"
FROM
solana.price.ez_prices_hourly
WHERE
hour BETWEEN '2024-09-01 00:00:00' AND '2024-09-30 23:59:59'
GROUP BY
token_address, symbol
)
SELECT
prc."symbol",
SUM(tb."bridged_amount" * prc."median_price") AS "total_volume_in_usd",
SUM(tb."bridged_amount" * prc."median_price") / 30 AS "average_daily_swap_volume_in_usd"
FROM
total_bridged tb
LEFT JOIN
prices prc
ON tb."bridged_token" = prc."token_address"
WHERE
tb.direction = 'inbound'
GROUP BY
Last run: 3 months ago
10
422B
5s