boomer77wormhole fees
Updated 2022-01-12
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with wormhole as (select date(block_timestamp) as dt, msg_value:sender::string as sender, tx_id,
msg_value:execute_msg:initiate_transfer:recipient_chain::string as chain,
msg_value:execute_msg:initiate_transfer:asset:amount as amount,
msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string as assets
from terra.msgs
where msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
and msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string is not null and tx_status = 'SUCCEEDED')
select tx_id, fee
from terra.transactions
where tx_id in (select tx_id from wormhole)
limit 100
Run a query to Download Data