AndyCoolUntitled Query
Updated 2021-10-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
SELECT
block_id,
block_timestamp,
tx_id,
msg_value:sender::string as sender,
msg_value:execute_msg:swap:offer_asset:amount / POW(10,6) as swap_amount,
msg_value:execute_msg:swap:offer_asset:info:native_token:denom::string as swap_currency,
tx_status,
c.address_name
FROM terra.msgs
LEFT OUTER JOIN terra.labels c
ON msg_value:contract::string = c.address
WHERE tx_id = '6D0BD445A0082F5973AFF35F1013DECE78A4DD4555AB073D9395E93B4E75687D'
LIMIT 1
Run a query to Download Data