0xHaM-dPlatform Users
Updated 2024-06-01Copy 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 Playwo / Platform Users @ https://flipsidecrypto.xyz/Playwo/q/nezppud5x8qs/platform-users
WITH timeframe AS (
SELECT date_day AS date
FROM crosschain.core.dim_dates
WHERE date_day >= TO_DATE('{{start_date}}')
AND date_day < CURRENT_DATE()
),
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_position_events AS (
SELECT a__contract_address.tx_id, a__contract_address.block_timestamp,
QueryRunArchived: QueryRun has been archived