DATE | BRIDGE | TOTAL_VOLUME | TOTAL_BRIDGES | |
|---|---|---|---|---|
1 | 2025-03-22 00:00:00.000 | Canonical | 422603.652559107 | 498 |
2 | 2025-03-21 00:00:00.000 | Canonical | 330265.360099305 | 1045 |
3 | 2025-03-20 00:00:00.000 | Canonical | 216644.881303362 | 657 |
4 | 2025-03-18 00:00:00.000 | Canonical | 477778.464718364 | 672 |
5 | 2025-03-17 00:00:00.000 | Canonical | 168465.747716126 | 597 |
6 | 2025-03-17 00:00:00.000 | Hyperlane | 1853879.73540005 | 1528 |
7 | 2025-03-23 00:00:00.000 | Canonical | 448768.113538099 | 538 |
8 | 2025-03-23 00:00:00.000 | Hyperlane | 2611457.409171 | 1289 |
9 | 2025-03-22 00:00:00.000 | Hyperlane | 2637654.21807217 | 1323 |
10 | 2025-03-21 00:00:00.000 | Hyperlane | 2552750.09964203 | 1910 |
11 | 2025-03-20 00:00:00.000 | Hyperlane | 3671362.84711891 | 1869 |
12 | 2025-03-19 00:00:00.000 | Canonical | 581967.704112046 | 545 |
13 | 2025-03-19 00:00:00.000 | Hyperlane | 3564304.36879992 | 1665 |
14 | 2025-03-18 00:00:00.000 | Hyperlane | 2489293.19213431 | 1418 |
0xHaM-dTotals By Bridge[Last Week]
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
, daily_gross_usd_volume
, total_gross_usd_volume
, events_count
from $query('19f93923-bf61-4c76-a496-194ee7e6d11f')
where date < trunc(current_date, 'week')
AND date >= trunc(current_date, 'week') - 7
order by date desc
-- limit 1
)
, canonical_bridges as (
select
'Canonical' as bridge
, date
, daily_gross_usd_volume
, total_gross_usd_volume
, events_count
from $query('3b847d0f-cb54-439d-90d7-a6c81442058c')
where date < trunc(current_date, 'week')
AND date >= trunc(current_date, 'week') - 7
order by date desc
-- limit 1
)
select
Last run: 9 days ago
14
861B
2s