dariustay_0512c. Wormhole Transactions - Fish / Whale
Updated 2022-01-12
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
terra_wormhole_tx AS (
SELECT
block_timestamp,
tx_id,
msg_value,
msg_value:sender::string AS address,
msg_value:execute_msg:initiate_transfer:asset:amount / POW(10,6) as tx_amt,
CASE
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 1 THEN 'SOLANA'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 2 THEN 'ETHEREUM'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 3 THEN 'TERRA'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 4 THEN 'BSC'
WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 5 THEN 'POLYGON'
ELSE 'TERRA'
END AS target_chain,
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
WHEN msg_value:execute_msg:initiate_transfer:asset:info:native_token IS NOT NULL THEN msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string
ELSE 'NULL'
END AS token
FROM terra.msgs
WHERE tx_status = 'SUCCEEDED'
AND msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
AND msg_value:execute_msg:initiate_transfer IS NOT NULL),
tokens AS (
SELECT
token,
CASE
-- wormhole
WHEN token = 'terra19t8cxscre0jss7nejqy29c97fkg7els3v8zujg' THEN 'wh'
WHEN token = 'terra1hd9n65snaluvf7en0p4hqzse9eqecejz2k8rl5' THEN 'wh'
WHEN token = 'terra16q5pke2vueu23y8punvj70h0cp0s0rc7vrzl57' THEN 'wh'
WHEN token = 'terra1e6mq63y64zcxz8xyu5van4tgkhemj3r86yvgu4' THEN 'wh'
WHEN token = 'terra1k7tstwhf25wm45x329ny84xe4n2z2nnq9ekuv2' THEN 'wh'
Run a query to Download Data