binhachonShuttle vs. Wormhole - Unique users - 90 days
    Updated 2022-01-18
    ------------------------------------------------------------------- Wormhole side ---------------------------------------------------------------------------
    with receiving_native_terra_asset as(
    select
    block_timestamp,
    event_attributes : recipient :: string as address,
    event_attributes : amount :: float / 1e6 as amount
    from
    terra.msg_events
    where event_type = 'from_contract'
    and event_attributes : action :: string = 'complete_transfer_terra_native'
    ),
    receiving_wrapped_asset as(
    select
    block_timestamp,
    event_attributes : recipient :: string as address,
    event_attributes : "1_contract_address" :: string as symbol,
    event_attributes : "0_amount" :: float / 1e6 as amount
    from
    terra.msg_events
    where event_type = 'from_contract'
    and event_attributes : "0_action" :: string = 'complete_transfer_wrapped'
    ),
    sending_asset as(
    select
    block_timestamp,
    msg_value : sender :: string as address,
    case when msg_value : execute_msg : initiate_transfer : asset : info : native_token : denom :: string is not null then msg_value : execute_msg : initiate_transfer : asset : info : native_token : denom :: string when msg_value : execute_msg : initiate_transfer : asset : info : token : contract_addr :: string is not null then msg_value : execute_msg : initiate_transfer : asset : info : token : contract_addr :: string end as symbol,
    msg_value : execute_msg : initiate_transfer : recipient_chain :: float as chain_ID,
    msg_value : execute_msg : initiate_transfer : asset : amount :: float / 1e6 as amount,
    msg_value
    from
    terra.msgs
    where
    msg_value : contract :: string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
    and tx_status = 'SUCCEEDED'
    and msg_value : execute_msg : initiate_transfer : recipient_chain is not null
    Run a query to Download Data