0-MIDtop 20 Route By $Volume (Arbitrum)
Updated 2024-10-29
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 case
when DECODED_LOG:bridgeData:destinationChainId=42161 then 'Arbitrum'
when DECODED_LOG:bridgeData:destinationChainId=324 then 'zkSync'
when DECODED_LOG:bridgeData:destinationChainId=8453 then 'Base'
when DECODED_LOG:bridgeData:destinationChainId=137 then 'Polygon'
when DECODED_LOG:bridgeData:destinationChainId=56 then 'BNB'
when DECODED_LOG:bridgeData:destinationChainId=59144 then 'Linea'
when DECODED_LOG:bridgeData:destinationChainId=1 then 'Ethereum'
when DECODED_LOG:bridgeData:destinationChainId=43114 then 'Avalanche'
when DECODED_LOG:bridgeData:destinationChainId=250 then 'Fantom'
when DECODED_LOG:bridgeData:destinationChainId=1101 then 'Polygon zkEVM'
when DECODED_LOG:bridgeData:destinationChainId=1088 then 'Metis'
when DECODED_LOG:bridgeData:destinationChainId=1151111081099710 then 'Solana'
when DECODED_LOG:bridgeData:destinationChainId=534352 then 'Scroll'
when DECODED_LOG:bridgeData:destinationChainId=34443 then 'Mode'
when DECODED_LOG:bridgeData:destinationChainId=1329 then 'Sei'
when DECODED_LOG:bridgeData:destinationChainId=81457 then 'Blast'
when DECODED_LOG:bridgeData:destinationChainId=100 then 'Gnosis'
when DECODED_LOG:bridgeData:destinationChainId=34443 then 'Mode'
when DECODED_LOG:bridgeData:destinationChainId=1313161554 then 'Aurora'
when DECODED_LOG:bridgeData:destinationChainId=167000 then 'Taiko'
when DECODED_LOG:bridgeData:destinationChainId=5000 then 'Mantle'
when DECODED_LOG:bridgeData:destinationChainId=42220 then 'Celo'
when DECODED_LOG:bridgeData:destinationChainId=252 then 'Fraxtal'
when DECODED_LOG:bridgeData:destinationChainId=30 then 'Rootstock'
when DECODED_LOG:bridgeData:destinationChainId=1284 then 'Moonbeam'
when DECODED_LOG:bridgeData:destinationChainId=1285 then 'Moonriver'
when DECODED_LOG:bridgeData:destinationChainId=122 then 'Fuse'
when DECODED_LOG:bridgeData:destinationChainId=288 then 'Boba' end as dst_chain
,TX_HASH
from optimism.core.ez_decoded_event_logs
where EVENT_NAME='LiFiTransferStarted'
and DECODED_LOG:bridgeData:integrator='jumper.exchange'
and ORIGIN_TO_ADDRESS='0x1231deb6f5749ef6ce6943a275a1d3e7486f4eae'
QueryRunArchived: QueryRun has been archived