TOTAL_VOLUME | TOTAL_BRIDGES | |
|---|---|---|
1 | 736439252.432699 | 142 |
0xHaM-dTotals Bridge[All Time]
Updated 9 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 Totals By Bridge[All Time] @ https://flipsidecrypto.xyz/studio/queries/4ab8462a-eba2-4983-bbaa-0c1a0efaba1b
-- 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
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: 9 days ago
1
24B
1s