SELECT

DISTINCT tx_id

FROM sei.core.fact_msg_attributes a

WHERE msg_type = 'execute'

AND attribute_key = '_contract_address'

AND block_timestamp:: date >= '2023-05-31'

AND ATTRIBUTE_VALUE IN (

'sei1zjryrejvtufeaaer7w55fxgxurqnajwlshdpuqf5lp4j00uzek8s6sktv3',

'sei14j7zhcj50qsk6vhu7dsa48r5e7v37nthnwwx0q8q4nd0h39udy6qhqq6dm',

,

close_position as (

SELECT

'close' as type,

block_timestamp,

tx_succeeded,

a.tx_id,

MSG_INDEX,

OBJECT_AGG(

attribute_key :: STRING,

attribute_value :: variant

) AS j,

j : "pos-owner" :: string as Trader,

j : leverage :: int as leverage,

j : direction :: string as direction,

j : "trading-fee-usd" :: double as fee_usd,

j : "deposit-collateral" :: double as amount,

j : "deposit-collateral-usd" :: double as amount_usd,

j : "active-collateral" :: double as active_collateral,

j : "pnl-usd" :: double as pnl_usd,

j : "take-profit-override" :: double as take_profit,