0xHaM-dDaily Share of Users
Updated 2023-11-02Copy Reference Fork
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
›
⌄
-- 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