0xHaM-dTrader Size
Updated 2024-06-01Copy Reference Fork
99
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 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