maybeyonaswormhole_hit_miss
    Updated 2022-02-15
    with
    into_wormhole as (
    select
    block_timestamp, tx_id,
    tx_status as status,
    case
    when msg_value:execute_msg:initiate_transfer:asset:info:token is not null then 'token'
    else 'native'
    end as type,
    case
    when msg_value:execute_msg:initiate_transfer:asset:info:token is not null
    then msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string
    else msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string
    end as asset,
    msg_value:execute_msg:initiate_transfer:asset:amount/pow(10,6) as amount,
    case msg_value:execute_msg:initiate_transfer:recipient_chain
    when 1 then 'solana'
    when 2 then 'ethereum'
    when 3 then 'terra'
    when 4 then 'binance'
    when 5 then 'polygon'
    when 6 then 'avalanche'
    when 7 then 'oasis'
    else 'woah sus'
    end as recipient_chain
    from terra.msgs
    where msg_value:execute_msg:initiate_transfer:recipient_chain is not null
    )

    select
    'terra' as source,
    recipient_chain as destination,
    status,
    asset,
    count(distinct tx_id) as txs
    from into_wormhole
    Run a query to Download Data