binhachon104. [Elite] Binance Comparison - Volume - Shuttle bridge histogram
    Updated 2021-12-06
    ------------------------------------------------------------------- Wormhole side ---------------------------------------------------------------------------
    with tx_id_with_chain as(
    select
    tx_id,
    HEX_ENCODE(
    BASE64_DECODE_BINARY(
    msg_value : execute_msg : submit_vaa : data :: string
    )
    ) as vaa_data,
    CASE WHEN vaa_data ILIKE '%ec7372995d5cc8732397fb0ad35c0121e0eaa90d26f828a534cab54391b3a4f5%' THEN 'Solana' WHEN vaa_data ILIKE '%0000000000000000000000003ee18b2214aff97000d974cf647e7c347e8fa585%' THEN 'Ethereum' WHEN vaa_data ILIKE '%000000000000000000000000b6f6d86a8f9879a9c87f643768d9efc38c1da6e7%' THEN 'BSC' WHEN vaa_data ILIKE '%0000000000000000000000005a58505a96d1dbf8df91cb21b54419fc36e93fde%' THEN 'Polygon' ELSE 'Unknown Chain' END as emitter_chain
    from
    terra.msgs
    where
    msg_value : contract :: string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
    and msg_value : execute_msg : submit_vaa is not null
    and tx_status = 'SUCCEEDED'
    ),
    receiving_native_terra_asset as(
    select
    block_timestamp,
    event_attributes : recipient :: string as address,
    event_attributes : denom :: string as symbol,
    event_attributes : amount :: float / 1e6 as amount
    from
    terra.msg_events
    where
    tx_id in(
    select
    tx_id
    from
    tx_id_with_chain
    where
    emitter_chain = 'BSC'
    )
    and event_type = 'from_contract'
    and event_attributes : action :: string = 'complete_transfer_terra_native'
    Run a query to Download Data