WITH levana_contracts AS ( SELECT $1 AS contract_address, $2 AS asset, $3 AS asset_decimals FROM (VALUES ('osmo1nzddhaf086r0rv0gmrepn3ryxsu9qqrh7zmvcexqtfmxqgj0hhps4hruzu', 'BTC', 6), ('osmo1hd7r733w49wrqnxx3daz4gy7kvdhgwsjwn28wj7msjfk4tde89aqjqhu8x', 'ATOM', 6), ('osmo127aqy4697zqn27z0vqr3x2n8lraf27t7udvl6ef5hcwmwhjadegq9vytdj', 'OSMO', 6), ('osmo19c7hdlfvu7cddr0smfz9luaj8375qhfr3s0gtsk087laqfzxlu3qsnk47e', 'ETH', 6), ('osmo186nlf2fwfglq8u4nj3f7mwg8uc79j22qhaau4scdyur47e0fatas34vcn9', 'SEI', 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 osmosis.core.fact_msg_attributes AS a__contract_address, osmosis.core.fact_msg_attributes AS a_notional_size, osmosis.core.fact_msg_attributes AS a_pos_owner, osmosis.core.fact_msg_attributes AS a_direction, osmosis.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) ), user_stats AS ( SELECT user, sum(size_usd) AS volume_usd, count(*) AS positions, count(DISTINCT asset) AS assets, avg(leverage) AS leverage FROM open_events JOIN levana_contracts ON contract = contract_address GROUP BY ALL ) SELECT CASE WHEN volume_usd < 1 THEN '< 1$' WHEN volume_usd < 10 THEN '< 10$' WHEN volume_usd < 100 THEN '< 100$' WHEN volume_usd < 1000 THEN '< 1000$' WHEN volume_usd < 10000 THEN '< 10000$' ELSE '> 10000$' END AS size, CASE WHEN volume_usd < 1 THEN 1 WHEN volume_usd < 10 THEN 2 WHEN volume_usd < 100 THEN 3 WHEN volume_usd < 1000 THEN 4 WHEN volume_usd < 10000 THEN 5 ELSE 6 END AS srt, count(*) AS users FROM user_stats GROUP BY ALL

Levana Performance Monitor (Osmosis)