-- forked from Playwo / Trader Size @ https://flipsidecrypto.xyz/Playwo/q/xbf-CnEtI5nj/trader-size

WITH levana_contracts AS (

SELECT $1 AS contract_address, $2 AS asset, $3 AS asset_decimals

FROM (VALUES

('sei1jvl8avv45sj92q9x9c84fq2ymddya6dkwv9euf7y365tkzma38zq5xldpy', 'ETH', 6),

('sei1zjryrejvtufeaaer7w55fxgxurqnajwlshdpuqf5lp4j00uzek8s6sktv3', 'ETH', 6),

('sei1rl9z38s9t853jddjfexxkqqpq5d5wpzrqudfg7ruchzymxhms7pq39j645', 'ETH', 6),

('sei14j7zhcj50qsk6vhu7dsa48r5e7v37nthnwwx0q8q4nd0h39udy6qhqq6dm','SEI', 6),

('sei1tasaxmw8axfmcmzg2m9zp24msuurfkz3m44mga2dl98eh0txcxjspw9rga','BTC', 6),

('sei1teg8l8lanhkdxcdffg9anrzt3hhv9d8967ajczlrq3lzdrkzczsskh6733','SOL', 6)

)

),

open_events AS (

SELECT

a__contract_address.tx_id,

a__contract_address.block_timestamp,

a__contract_address.attribute_value AS contract,

a_notional_size.attribute_value AS size_usd,

a_pos_owner.attribute_value AS user,

a_direction.attribute_value AS direction,

a_leverage.attribute_value AS leverage

FROM

sei.core.fact_msg_attributes AS a__contract_address,

sei.core.fact_msg_attributes AS a_notional_size,

sei.core.fact_msg_attributes AS a_pos_owner,

sei.core.fact_msg_attributes AS a_direction,

sei.core.fact_msg_attributes AS a_leverage

WHERE a__contract_address.attribute_key = '_contract_address'

AND a_notional_size.attribute_key = 'notional-size' AND a__contract_address.tx_id = a_notional_size.tx_id AND a__contract_address.msg_index = a_notional_size.msg_index AND (a__contract_address.msg_group = a_notional_size.msg_group OR a__contract_address.msg_group IS NULL AND a_notional_size.msg_group IS NULL)

AND a_pos_owner.attribute_key = 'pos-owner' AND a__contract_address.tx_id = a_pos_owner.tx_id AND a__contract_address.msg_index = a_pos_owner.msg_index AND (a__contract_address.msg_group = a_pos_owner.msg_group OR a__contract_address.msg_group IS NULL AND a_pos_owner.msg_group IS NULL)

AND a_direction.attribute_key = 'direction' AND a__contract_address.tx_id = a_direction.tx_id AND a__contract_address.msg_index = a_direction.msg_index AND (a__contract_address.msg_group = a_direction.msg_group OR a__contract_address.msg_group IS NULL AND a_direction.msg_group IS NULL)

AND a_leverage.attribute_key = 'leverage' AND a__contract_address.tx_id = a_leverage.tx_id AND a__contract_address.msg_index = a_leverage.msg_index AND (a__contract_address.msg_group = a_leverage.msg_group OR a__contract_address.msg_group IS NULL AND a_leverage.msg_group IS NULL)

),