bachiLuna - warmwhole
Updated 2021-11-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
⌄
/*select * from terra.msgs
where msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
and msg_value:execute_msg:initiate_transfer is not null
and msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string is not null
and tx_status = 'SUCCEEDED'*/
--The above query gives tokens sent from terra to other block-chains through wormhole.
--Tokens sent to terra from other block chains using wormhole
SELECT *
from terra.msg_events
where event_attributes:"0_contract_address"::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
and event_type = 'from_contract'
and event_attributes:"0_action"::string = 'complete_transfer_wrapped'
and tx_status = 'SUCCEEDED'
Run a query to Download Data