SYMBOL | BRIDGES | VOLUME_BRIDGED | |
|---|---|---|---|
1 | USDC | 930 | 1399419.12642866 |
2 | ETH | 293 | 139597.797103399 |
3 | WETH | 18 | 12479.925652434 |
4 | WEETH.BASE | 1 | 560.26616179 |
5 | ODOS | 1 | 112.299347633 |
0-MIDtoken_1
Updated 2025-03-14
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 base.core.ez_decoded_event_logs
where EVENT_NAME='LiFiTransferStarted'
and DECODED_LOG:bridgeData:integrator='jumper.exchange'
and DECODED_LOG:bridgeData:destinationChainId='146'
),
tab2 as (
select HOUR::date as day
,TOKEN_ADDRESS
,SYMBOL
,DECIMALS
,avg(PRICE) as usd_price
from base.price.ez_prices_hourly
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 base.price.ez_prices_hourly
where SYMBOL='WETH'
group by 1,2,3,4
)
select SYMBOL
,count(distinct TX_HASH) as bridges
,sum(volume/pow(10,DECIMALS)*usd_price) as volume_bridged
from tab1
left join tab2
Last run: 29 days ago
5
143B
77s