0-MIDtop 20 Route By $Volume (Arbitrum)
    Updated 2024-10-29

    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