maybeyonaswormhole_hit_miss
Updated 2022-02-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with
into_wormhole as (
select
block_timestamp, tx_id,
tx_status as status,
case
when msg_value:execute_msg:initiate_transfer:asset:info:token is not null then 'token'
else 'native'
end as type,
case
when msg_value:execute_msg:initiate_transfer:asset:info:token is not null
then msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string
else msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string
end as asset,
msg_value:execute_msg:initiate_transfer:asset:amount/pow(10,6) as amount,
case msg_value:execute_msg:initiate_transfer:recipient_chain
when 1 then 'solana'
when 2 then 'ethereum'
when 3 then 'terra'
when 4 then 'binance'
when 5 then 'polygon'
when 6 then 'avalanche'
when 7 then 'oasis'
else 'woah sus'
end as recipient_chain
from terra.msgs
where msg_value:execute_msg:initiate_transfer:recipient_chain is not null
)
select
'terra' as source,
recipient_chain as destination,
status,
asset,
count(distinct tx_id) as txs
from into_wormhole
Run a query to Download Data