RayyykAxelar Bridge 1
    Updated 2022-10-28
    with table_1 as (select tx_id,
    sender,
    amount/pow(10, decimal) as volume,
    case
    when sender like '%agoric%' then 'Agoric'
    when sender like '%evmos%' then 'Evmos'
    when sender like '%comdex%' then 'Comdex'
    when sender like '%mantle%' then 'Asset Mantle'
    when sender like '%terra%' then 'Terra'
    when sender like '%kujira%' THEN 'Kujira'
    when sender like '%osmo%' then 'Osmo'
    when sender like '%juno%' then 'Juno'
    when sender like '%secret%' then 'Secret'
    when sender like '%fetch%' then 'Fetch'
    when sender like '%persistence%' then 'Persistence'
    when sender like '%cosmos%' then 'Cosmos'
    when sender like '%umee%' then 'Umee'
    when sender like '%regen%' then 'Regen'
    when sender like '%stars%' then 'Stargaze'
    when sender like 'ki%' then 'Ki'
    when sender like '%cre%' then 'Crescent'
    when sender like '%emoney%' then 'E-money'
    when sender like '%axelar%' then 'Axelar'
    end as sender_origin,
    receiver,
    case
    when receiver like '%agoric%' then 'Agoric'
    when receiver like '%evmos%' then 'Evmos'
    when receiver like '%mantle%' then 'Asset Mantle'
    when receiver like '%terra%' then 'Terra'
    when receiver like '%kujira%' THEN 'Kujira'
    when receiver like '%osmo%' then 'Osmo'
    when receiver like '%juno%' then 'Juno'
    when receiver like '%secret%' then 'Secret'
    when receiver like '%cosmos%' then 'Cosmos'
    when receiver like '%kava%' then 'Kava'
    Run a query to Download Data