Afonso_Diaz2023-08-29 07:54 PM
Updated 2023-08-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
select
a.attribute_value as amount_in,
b.attribute_value as amount_out
from sei.core.fact_msg_attributes a
join sei.core.fact_msg_attributes b
using(tx_id, block_timestamp)
where tx_id = '95086F5457AC9E262D75889C7AC9FA8DECFAD7BEC2A68503059DABE376719CC1'
and a.attribute_key = 'offer_amount'
and b.attribute_key = 'return_amount'
and a.attribute_value != b.attribute_value
--and attribute_key = 'amount'
Run a query to Download Data