maybeyonassunchaser
Updated 2021-11-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
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