BRIDGE | TOTAL_VOLUME | TOTAL_BRIDGES | |
|---|---|---|---|
1 | Canonical | 137622112.446467 | 46 |
2 | Hyperlane | 598817139.986232 | 96 |
0xHaM-dTotals By Bridge[All Time]
Updated 10 days ago
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 flyingfish / Totals By Bridge @ https://flipsidecrypto.xyz/flyingfish/q/qLXRXm5P4Pdm/totals-by-bridge
with hyperlane_bridges as (
select
'Hyperlane' as bridge
, date
, total_gross_usd_volume
, events_count
from $query('19f93923-bf61-4c76-a496-194ee7e6d11f')
order by date desc
limit 1
)
, canonical_bridges as (
select
'Canonical' as bridge
, date
, total_gross_usd_volume
, events_count
from $query('3b847d0f-cb54-439d-90d7-a6c81442058c')
order by date desc
limit 1
)
select
bridge
, sum(total_gross_usd_volume) as total_volume
, sum(events_count) as total_bridges
from (
select * from canonical_bridges
union all
select * from hyperlane_bridges
)
Last run: 10 days ago
2
69B
2s