0xHaM-dTrader Size
    Updated 2024-06-01
    -- 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
    ('osmo1nzddhaf086r0rv0gmrepn3ryxsu9qqrh7zmvcexqtfmxqgj0hhps4hruzu', 'BTC', 6),
    ('osmo1hd7r733w49wrqnxx3daz4gy7kvdhgwsjwn28wj7msjfk4tde89aqjqhu8x', 'ATOM', 6),
    ('osmo127aqy4697zqn27z0vqr3x2n8lraf27t7udvl6ef5hcwmwhjadegq9vytdj', 'OSMO', 6),
    ('osmo19c7hdlfvu7cddr0smfz9luaj8375qhfr3s0gtsk087laqfzxlu3qsnk47e', 'axlETH', 6),
    ('osmo186nlf2fwfglq8u4nj3f7mwg8uc79j22qhaau4scdyur47e0fatas34vcn9', 'SEI', 6),
    ('osmo1d5zsvupzvq5ru6635a0agrcdrj0t8ycj8vpewm8z4y8xf85gvh3qk0ka33', 'DOT', 6),
    ('osmo16v36jtfjc933htukqfrk8lk8e2uj8xpp3zjdh0ll04qe9jevlnrsuwhhx8', 'EURO', 6),
    ('osmo1rhgn3mp5q7vfr43xgzwtcrnklll6w7e0gv5jvmk9sz26qvcnf3tsw8axyn', 'GBP', 6),
    ('osmo164357hnc5jc0pw9lv958h6chrpjucr4sy47hwpm9k4av6zh74gnq7uvcpj', 'BNB', 6),
    ('osmo1ufpu3nudumzh53sek246zrwvv2cc7leplaqruuggeny7wlcvfrzq4cqmwd', 'stATOM', 6),
    ('osmo1kqzkupfec3zemmaj3kuhcf0h2wke02wa7sgp2a9vq5mugtgs5pzs8avjzt', 'TIA', 6),
    ('osmo1jprh8f4ytxar0q3z5n5p6swqnmunnsvuuhnhteskwxjzyc8jayms4r7e3e', 'SOL', 6),
    ('osmo1353cxacx74lfugp0sdkdpasa7d09rlwwdaeeql9usw2w6g773vqsxgp053', 'INJ', 6),
    ('osmo19uqdjvk6j9yjtev7j25sc0v0mszqy3jwwak8z4n0qf6l4wp9csvq0jn0qw', 'LINK', 6),
    ('osmo1u7usfl8wxtzkwllagxxv9u0y5ulv4gyan47gmn76re0830ndk8hsnd05l9', 'LUNA', 6),
    ('osmo1my45yym085dj5jxrtdgy2y4wjlvxf2uwp8plmxq25e0phdyuckzqq5r73w', 'DYDX', 6),
    ('osmo1mrc3zk2fvqvcg9j693u0mlcd8g6329e3w9ld4t7qg20635sfcvuswaxgjm', 'RUNE', 6),
    ('osmo19ua8dlul0hq9jfwfq9d0eqcz0lvx5jd8segmn85rz2nv94jlhwcqnkypv3', 'DOGE', 6),
    ('osmo1gprafrgxx0tlf4u3dxnxcvvmsg2yl4hgqxc68xmkq07h2n0lk9zqycckgc', 'AVAX', 6),
    ('osmo1dyt0wupd5sdefwh53y6e6murnnpfeg27rc7aknhm7tynqzphuwfsr7d4h2', 'NTRN', 6),
    ('osmo1wszczd8y6lk53ygr59cxt60ualydtwsnr7tu63zkgvu704r7yqdshc47w8', 'PYTH', 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,
    QueryRunArchived: QueryRun has been archived