Saleh2023-09-20 10:50 AM
Updated 2023-09-20
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
›
⌄
with main AS (select
m.BLOCK_TIMESTAMP,m.TX_ID,CASE
when ATTRIBUTE_VALUE in (
'sei1jvl8avv45sj92q9x9c84fq2ymddya6dkwv9euf7y365tkzma38zq5xldpy',
'sei1zjryrejvtufeaaer7w55fxgxurqnajwlshdpuqf5lp4j00uzek8s6sktv3'
) then 'ETH/USD'
else 'SEI/USD'
end AS Pool,long_interest,short_interest
from sei.core.fact_msg_attributes m
inner join (
select
TX_ID,ATTRIBUTE_VALUE AS long_interest
from sei.core.fact_msg_attributes
where
TX_SUCCEEDED = TRUE
and MSG_TYPE = 'wasm-delta-neutrality-ratio'
and ATTRIBUTE_KEY = 'long-interest'
) A on A.TX_ID=m.TX_ID
inner join (
select
TX_ID,ATTRIBUTE_VALUE AS short_interest
from sei.core.fact_msg_attributes
where
TX_SUCCEEDED = TRUE
and MSG_TYPE = 'wasm-delta-neutrality-ratio'
and ATTRIBUTE_KEY = 'short-interest'
) B on B.TX_ID=m.TX_ID
where
TX_SUCCEEDED = TRUE
and MSG_TYPE = 'wasm-delta-neutrality-ratio'
and ATTRIBUTE_KEY = '_contract_address'),
main2 AS (
select
Day,
sum(long_interest) AS long_interest,
sum(short_interest) AS short_interest
Run a query to Download Data