DATE | VOLUME_IN | VOLUME_OUT | TOTAL_VOLUME_IN | TOTAL_VOLUME_OUT | TOTAL_GROSS_VOLUME | TOTAL_BRIDGE_TVL | COUNTER | TOTAL_BRIDGES | AVG_USD_BRIDGE_SIZE | |
|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-23 00:00:00.000 | 1558256.01522727 | -1501969.50748183 | 12224402.1091011 | -9802793.68528373 | 22027195.7943848 | 155714315.319985 | 1827 | 15554 | 1416.175632917 |
2 | 2025-03-22 00:00:00.000 | 1823195.69013145 | -1237062.18049983 | 10666146.0938738 | -8300824.1778019 | 18966970.2716757 | 154871705.946301 | 1821 | 13727 | 1381.727272651 |
3 | 2025-03-21 00:00:00.000 | 1622724.94609531 | -1260290.51364602 | 8842950.40374234 | -7063761.99730207 | 15906712.4010444 | 153509485.08811 | 2955 | 11906 | 1336.024895099 |
4 | 2025-03-20 00:00:00.000 | 2005691.45287639 | -1882316.27554588 | 7220225.45764702 | -5803471.48365605 | 13023696.9413031 | 153810493.8057 | 2526 | 8951 | 1454.999099688 |
5 | 2025-03-19 00:00:00.000 | 2319959.97571074 | -1826312.09720121 | 5214534.00477063 | -3921155.20811017 | 9135689.2128808 | 155715206.941071 | 2210 | 6425 | 1421.897153756 |
6 | 2025-03-18 00:00:00.000 | 1755821.30546823 | -1211250.35138445 | 2894574.02905989 | -2094843.11090896 | 4989417.13996885 | 147746398.287336 | 2090 | 4215 | 1183.72885883 |
7 | 2025-03-17 00:00:00.000 | 1138752.72359166 | -883592.75952451 | 1138752.72359166 | -883592.75952451 | 2022345.48311617 | 148995248.131389 | 2125 | 2125 | 951.691992055 |
0xHaM-dAll bridges by Bridge[Last Week]
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
›
⌄
-- forked from All bridges by Bridge @ https://flipsidecrypto.xyz/studio/queries/779fe3c9-7762-4662-9b80-1fb9ee52c542
-- forked from flyingfish / All bridges by Bridge @ https://flipsidecrypto.xyz/flyingfish/q/KgBj40aaWPtd/all-bridges-by-bridge
with hyperlane_bridges as (
select
'Hyperlane' as bridge
, date
, volume_usd_in
, volume_usd_out
, tvl_usd
, events_count
from $query('19f93923-bf61-4c76-a496-194ee7e6d11f')
)
, canonical_bridges as (
select
'Canonical' as bridge
, date
, volume_usd_in
, volume_usd_out
, tvl_usd
, events_count
from $query('3b847d0f-cb54-439d-90d7-a6c81442058c')
group by all
)
, aggregated as (
select
date
, zeroifnull(a.volume_usd_in) + zeroifnull(b.volume_usd_in) as volume_in
, zeroifnull(a.volume_usd_out) + zeroifnull(b.volume_usd_out) as volume_out
, sum(volume_in) over (order by date) as total_volume_in
, sum(volume_out) over (order by date) as total_volume_out
, total_volume_in - total_volume_out as total_gross_volume
, a.tvl_usd + b.tvl_usd as total_bridge_tvl
Last run: 10 days ago
7
1KB
1s