AndyCoolpylon hunt
    Updated 2021-10-28
    SELECT
    block_id,
    block_timestamp,
    tx_id,
    msg_value:sender::string as sender,
    msg_value:execute_msg:swap:offer_asset:amount / POW(10,6) as swap_amount,
    msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_currency,
    tx_status,
    c.address_name
    FROM terra.msgs
    LEFT OUTER JOIN terra.labels c
    ON msg_value:contract::string = c.address
    WHERE tx_id = '6D0BD445A0082F5973AFF35F1013DECE78A4DD4555AB073D9395E93B4E75687D'
    LIMIT 1