binhachonUntitled Query
Updated 2022-04-05
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select * from terra.msg_events
where tx_id = '2DF6F6DBAF386F8CB75139E9EA74A6D1D521B4BCD5EF8515A688C72366AE33CA'
select
msg_index,
count(*)-- Burn LUNA mint UST
from terra.msgs
where msg_value:contract::string = 'terra1vs9jr7pxuqwct3j29lez3pfetuu8xmq7tk3lzk'
and msg_value:execute_msg:assert_limit_order:ask_denom::string = 'uusd'
and msg_value:execute_msg:assert_limit_order:offer_coin:denom::string = 'uluna'
and tx_status = 'SUCCEEDED'
group by 1
-- limit 10
Run a query to Download Data