cloudr3n2023-11-01 11:16 PM
Updated 2023-11-02
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
›
⌄
⌄
select
block_timestamp,
tx_id,
attribute_value,
parse_json(attribute_value) as value1,
parse_json(value1:receiver) as value2,
value2:autopilot:stakeibc as value3,
value3:action
from
cosmos.core.fact_msg_attributes
where
tx_id = '4689EABCF9D95DB4AB30FDE103069BA079EDA7DAA249C84438D4F053D7DF0CC3'
and msg_type = 'send_packet'
and attribute_key = 'packet_data'
/*
stosmosis:
select * from osmosis.core.fact_tx_body_msgs
where tx_id='71E06B05D7CCC4E2686017F26FC359440235B1079BDE11C637CB30D3FC210774'
stATOM:
select
block_timestamp,
tx_id,
attribute_value
from
cosmos.core.fact_msg_attributes
where --tx_id='4689EABCF9D95DB4AB30FDE103069BA079EDA7DAA249C84438D4F053D7DF0CC3'
1=1
and msg_type='send_packet'
and attribute_key='packet_data''
{"amount":"100000","denom":"uatom",
"receiver":"{\
"autopilot\":{\
"stakeibc\":{\
"stride_address\":\"stride1c504ex0lsprwskhecynwk5dyfk2h0za7x0elfe\",\"action\":\"LiquidStake\"
Run a query to Download Data