maybeyonassunchaser
    Updated 2021-11-11
    select
    msg_value:sender::string as sender,
    msg_value:coins[0]:amount/pow(10,6) as usd_amt,
    msg_value:execute_msg:zap_into_strategy:strategy_id as strategy_id,
    case msg_value:execute_msg:zap_into_strategy:strategy_id
    when 29 then 'MINE-UST'
    else 'ANC-UST' end as Vault,
    tx_id
    from terra.msgs
    where
    tx_id in ('3F8AB8211E382D62C7259E98EE6D75E9F8196A5EEB0D5C19F0272AB6FB24EB25','ADC61A0E488AF95FA4FCFE5D19864A57A5F0B6BFB7A2892492664700637C6721')
    Run a query to Download Data