CHAIN | VOLUME_BRIDGED | AVG | MED | BRIDGES | BRIDGERS | |
|---|---|---|---|---|---|---|
1 | Boba | 201.850396825 | 25.231299603 | 7.219253668 | 8 | 8 |
0-MIDlast 24H
Updated 2025-03-31
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
›
⌄
with tab1 as (
select BLOCK_TIMESTAMP::date as day
,DECODED_LOG:bridgeData:bridge as protocol
,DECODED_LOG:bridgeData:sendingAssetId as token_address
,DECODED_LOG:bridgeData:minAmount as volume
,DECODED_LOG:bridgeData:destinationChainId as dst_chain
,ORIGIN_FROM_ADDRESS
,TX_HASH
from boba.core.ez_decoded_event_logs
where EVENT_NAME='LiFiTransferStarted'
and DECODED_LOG:bridgeData:integrator='jumper.exchange'
and BLOCK_TIMESTAMP::date>=current_date-1
),
tab2 as (
select HOUR::date as day
,TOKEN_ADDRESS
,SYMBOL
,DECIMALS
,avg(PRICE) as usd_price
from boba.price.ez_prices_hourly
where HOUR::date>=current_date-1
group by 1,2,3,4
union all
select HOUR::date as day
,'0x0000000000000000000000000000000000000000' as TOKEN_ADDRESS
,'ETH' as SYMBOL
,'18' as DECIMALS
,avg(PRICE) as usd_price
from boba.price.ez_prices_hourly
where SYMBOL='WETH'
and HOUR::date>=current_date-1
group by 1,2,3,4
)
select 'Boba' as chain
,sum(volume/pow(10,DECIMALS)*usd_price) as volume_bridged
,avg(volume/pow(10,DECIMALS)*usd_price) as avg
Last run: 23 days ago
1
53B
5s