KeyrockAstroport stSEI/SEI Liquidity -- old
Updated 2024-03-25
999
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 tx_id, BASE64_DECODE_STRING(msgs[8]:attributes[0]:value) AS decoded_value
FROM sei.core.fact_transactions
WHERE MSGS LIKE 'c2VpMWpxa3FwN3FsMG45ZWRwOWU3eTg2em50MG0yaDdyc3RsYzJyd2Z2eXh6cmo4NGV0OWN6YXE4OXVxZHg=%'
QUALIFY ROW_NUMBER() OVER (PARTITION BY BASE64_DECODE_STRING(msgs[8]:attributes[0]:value) ORDER BY RANDOM()) = 1
limit 2;
*/
/*
sample hash add liq, 656753C3D32669097C9D8B8D7B8EC887EF42EC4A1A514644619B80D5A6F38DE4 stsei/sei tx
sample hash remov liq -- 9FC8D816373763A260F7154557BE3196577ECF8825427AF92D7C1BED07B87078 stsei/sei tx
lp token, sei1jqkqp7ql0n9edp9e7y86znt0m2h7rstlc2rwfvyxzrj84et9czaq89uqdx
https://dexscreener.com/sei/sei1jqkqp7ql0n9edp9e7y86znt0m2h7rstlc2rwfvyxzrj84et9czaq89uqdx
*/
/*
----------------------Provide Liquidity----------------------------------
*/
/*
SELECT
tx_id,
REGEXP_SUBSTR(BASE64_DECODE_STRING(msgs[23]:attributes[4]:"value"), '\\d+')/1e6 AS amount_stSEI,
SUBSTR(REGEXP_SUBSTR(BASE64_DECODE_STRING(msgs[23]:attributes[4]:"value"), ',\\s(\\d+)'), 3)/1e6 AS amount_2_sei
FROM
sei.core.fact_transactions
WHERE
msgs[14]:attributes[2]:"value"='cHJvdmlkZV9saXF1aWRpdHk=' -- provide liq
and msgs[7]:attributes[0]:"value"='c2VpMWxuN250c3FteGw4czUwMmY4M2ttOWE0NzV6eWhjZmhwajd2MmZzbTNwY21ja2R5eXMzdHNrdHg5dms=' -- contract
*/
/*
----------------------Withdraw Liquidity----------------------------------
QueryRunArchived: QueryRun has been archived