DESTINATION_CHAIN | NUM_BRIDGES | BRIDGED_VOLUME | |
|---|---|---|---|
1 | osmosis | 142444 | 266025123.247125 |
2 | polygon | 129739 | 58526952.5881745 |
3 | arbitrum | 101757 | 102505782.950974 |
4 | base | 79247 | 97265675.5004244 |
5 | binance | 69759 | 140980896.626315 |
6 | fantom | 59588 | 124034331.345 |
7 | optimism | 51080 | 39581485.8827992 |
8 | celo | 49630 | 76099452.9699693 |
9 | linea | 28249 | 20042325.381081 |
10 | blast | 27829 | 51975672.2820476 |
saeedmzn[Squid router ] - Popular destination chains by num bridges
Updated 2025-01-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
›
⌄
-- forked from [Squid router ] - Total @ https://flipsidecrypto.xyz/edit/queries/bd555e4f-6899-4afe-a6c4-a2d62d3937d2
-- forked from [Squid router ] - over time @ https://flipsidecrypto.xyz/edit/queries/b8c69fcd-22d0-4cae-9755-630678788614
with bridge_transactions as (
select BLOCK_TIMESTAMP,
SENDER,
SOURCE_CHAIN,
DESTINATION_CHAIN,
TOKEN_ADDRESS,
TOKEN_SYMBOL,
AMOUNT,
TX_HASH
from axelar.defi.ez_bridge_squid
where BLOCK_TIMESTAMP::date >= '2024-01-01'
),
token_prices as (
select date_trunc(day,HOUR)::date date ,
TOKEN_ADDRESS,
SYMBOL,
avg(PRICE) usd_price
from crosschain.price.ez_prices_hourly
where date_trunc(day,HOUR)::date >= '2024-01-01'
group by 1,2,3
),
transactions_prices as (
select BLOCK_TIMESTAMP,
SENDER,
SOURCE_CHAIN,
DESTINATION_CHAIN,
b.TOKEN_ADDRESS,
b.TOKEN_SYMBOL,
AMOUNT,
AMOUNT * zeroifnull(usd_price) amount_usd ,
TX_HASH
from bridge_transactions b left join token_prices p
Last run: 3 months ago
10
341B
9s