nickpayiatis_Terra Messages Investigation
Updated 2021-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
SELECT
date_trunc('day',block_timestamp) as block_day,
tx_id as tx_hash,
msg_value:sender as sender,
msg_value as luna_unbonded
FROM terra.msgs
WHERE
msg_value:contract = 'terra1kc87mu460fwkqte29rquh4hc20m54fxwtsx7gp' -- Contract for BLUNA
AND
msg_value:execute_msg:send:contract = 'terra1mtwph2juhj0rvjz7dy92gvl6xvukaxu8rfv8ts'
AND
msg_value:execute_msg:send:msg::string='{"unbond":{}}' -- msg emitted during unbonding
And
block_day >= CURRENT_DATE - 1
AND
tx_status = 'SUCCEEDED'
GROUP BY 1,2,3,4
ORDER BY 4 DESC
LIMIT 10
Run a query to Download Data