0xHaM-dDaily Share of Users
    Updated 2023-11-02
    -- forked from Users Total copy @ https://flipsidecrypto.xyz/edit/queries/0310e2ac-11e9-4bc2-bb9e-853fc1fac327

    -- forked from Playwo / Users Total @ https://flipsidecrypto.xyz/Playwo/q/jnbOOVFcO0wH/users-total

    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_position_events AS (
    SELECT
    a__contract_address.tx_id,
    a__contract_address.block_timestamp,
    a__contract_address.attribute_value AS contract,
    a_pos_owner.attribute_value AS user,
    a_deposit_collateral.attribute_value AS collateral,
    a_deposit_collateral_usd.attribute_value AS collateral_usd,
    a_direction.attribute_value AS direction,
    a_notional_size.attribute_value AS notional_size
    FROM
    sei.core.fact_msg_attributes AS a__contract_address,
    sei.core.fact_msg_attributes AS a_pos_owner,
    sei.core.fact_msg_attributes AS a_deposit_collateral,
    sei.core.fact_msg_attributes AS a_deposit_collateral_usd,
    sei.core.fact_msg_attributes AS a_direction,
    sei.core.fact_msg_attributes AS a_notional_size
    WHERE a__contract_address.attribute_key = '_contract_address'
    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_deposit_collateral.attribute_key = 'deposit-collateral' AND a__contract_address.tx_id = a_deposit_collateral.tx_id AND a__contract_address.msg_index = a_deposit_collateral.msg_index AND (a__contract_address.msg_group = a_deposit_collateral.msg_group OR a__contract_address.msg_group IS NULL AND a_deposit_collateral.msg_group IS NULL)
    AND a_deposit_collateral_usd.attribute_key = 'deposit-collateral-usd' AND a__contract_address.tx_id = a_deposit_collateral_usd.tx_id AND a__contract_address.msg_index = a_deposit_collateral_usd.msg_index AND (a__contract_address.msg_group = a_deposit_collateral_usd.msg_group OR a__contract_address.msg_group IS NULL AND a_deposit_collateral_usd.msg_group IS NULL)
    Run a query to Download Data