TRADER | STRD_BOUGHT | STRD_SOLD | NET_STRD_POS | PCNT_SUPPLY | SWAPS | FIRST_BUY | LAST_BUY | |
|---|---|---|---|---|---|---|---|---|
1 | osmo1aff76avnwpnk02wxkc6n5xnwasjkgekazvl8xj | 301492 | 0 | 301492 | 0.3 | 26 | 2024-01-06 00:00:00.000 | 2024-01-24 00:00:00.000 |
2 | osmo10fata4x4fxzcsdqpe5cdzh482l4qqqk4vza7vv | 423054 | 247412 | 175642 | 0.18 | 311 | 2023-11-03 00:00:00.000 | 2024-01-23 00:00:00.000 |
3 | osmo1egcu5audv64tuv28q0x8hth3nnnjv7me0w8ufk | 151756 | 0 | 151756 | 0.15 | 38 | 2023-11-13 00:00:00.000 | 2024-02-06 00:00:00.000 |
4 | osmo1lt83tymrlkcg7jtfrzv5370z9uthttpvljxzmv | 141969 | 0 | 141969 | 0.14 | 119 | 2023-11-22 00:00:00.000 | 2024-01-24 00:00:00.000 |
5 | osmo1vz2at3w7v34cju347u4gtmuje5j4tmjxm3t75l | 117978 | 0 | 117978 | 0.12 | 68 | 2023-09-12 00:00:00.000 | 2023-09-30 00:00:00.000 |
6 | osmo17avktfjg2alyrfwd55vsjmj3hkv90733w7e0lm | 96117 | 0 | 96117 | 0.1 | 30 | 2024-01-04 00:00:00.000 | 2024-02-06 00:00:00.000 |
7 | osmo1qp3ev9whwl3p2gwnd0aurmujzurk527lnth6y4 | 69756 | 0 | 69756 | 0.07 | 23 | 2024-01-05 00:00:00.000 | 2024-02-01 00:00:00.000 |
8 | osmo1gm9stluhw4xklwyv5kwx9v3veqsm2uq9cr6zt8 | 103612 | 43846 | 59766 | 0.06 | 110 | 2023-10-01 00:00:00.000 | 2024-02-06 00:00:00.000 |
9 | osmo1hu5jz0d0y9q0yw8aa4z5kurq3p6yytlzgdl8ls | 73085 | 13548 | 59537 | 0.06 | 209 | 2023-09-12 00:00:00.000 | 2024-02-06 00:00:00.000 |
10 | osmo1jca5q6zcjnvhf5v776m8h0xfzqra2y6k6ys9l0y787grc7k44j8swensf6 | 109043 | 52686 | 56357 | 0.06 | 11359 | 2023-12-14 00:00:00.000 | 2024-01-19 00:00:00.000 |
11 | osmo1k5zzsku4cz6mtm73tq6jt47e6n8l8a5u7llfmg | 62601 | 7091 | 55510 | 0.06 | 116 | 2023-09-11 00:00:00.000 | 2024-01-25 00:00:00.000 |
12 | osmo1lg4paas0q9t0mqzmhrhpxkw3qh9cecaekvukgl | 54928 | 0 | 54928 | 0.05 | 17 | 2023-12-05 00:00:00.000 | 2024-01-08 00:00:00.000 |
13 | osmo1frrjpqp3k5a94mpvevljaq4hrh9nr2hh8lfm39 | 46681 | 0 | 46681 | 0.05 | 15 | 2024-01-10 00:00:00.000 | 2024-02-02 00:00:00.000 |
14 | osmo1teedp0gpsawryh74llws240unygv80z9eurqrt | 43555 | 0 | 43555 | 0.04 | 29 | 2023-10-17 00:00:00.000 | 2023-10-23 00:00:00.000 |
15 | osmo1qxjqx3425shtqdhr2vsu8aefkv7jy06t39dc8e | 42102 | 0 | 42102 | 0.04 | 15 | 2023-11-17 00:00:00.000 | 2023-11-17 00:00:00.000 |
16 | osmo1q8xsmaglhtz6geafkyk0slyplgmqyv29e7d5uz | 41845 | 0 | 41845 | 0.04 | 7 | 2023-12-14 00:00:00.000 | 2024-02-05 00:00:00.000 |
17 | osmo10vv8ddknjfy3muhvdx4uad4tfpasgzmmru470e | 39263 | 54 | 39209 | 0.04 | 22 | 2023-12-12 00:00:00.000 | 2024-02-06 00:00:00.000 |
18 | osmo1sjl5mhsxhxyxe3ael6qawu7m2qkaahdu75gqhq | 38624 | 0 | 38624 | 0.04 | 8 | 2023-12-13 00:00:00.000 | 2023-12-16 00:00:00.000 |
19 | osmo15yx5xg670usc4pg5zmwc3zrpfguv0rfp8ha4jl | 37707 | 0 | 37707 | 0.04 | 111 | 2023-09-16 00:00:00.000 | 2024-01-10 00:00:00.000 |
20 | osmo15jw7xccxaxk30lf4xgag8f7aeg53pgkh74e39rv00xfnymldjaas2fk627 | 45620 | 9570 | 36050 | 0.04 | 324 | 2023-09-18 00:00:00.000 | 2024-02-08 00:00:00.000 |
tomingTop 50 Net-Buyers in STRD-OSMO pool copy
Updated 2024-02-08
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
›
⌄
-- forked from onchainbrain / Top 50 Net-Buyers in STRD-OSMO pool @ https://flipsidecrypto.xyz/onchainbrain/q/EZj3jptNnDku/top-50-net-buyers-in-strd-osmo-pool
SELECT
top 50
trader,
round(sum(iff("TO_CURRENCY" = 'ibc/A8CA5EE328FA10C9519DF6057DA1F69682D28F7D0F5CCC7ECB72E3DCA2D157A4',
(to_amount / pow(10, "TO_DECIMAL")),0))) as strd_bought,
round(sum(iff("FROM_CURRENCY" = 'ibc/A8CA5EE328FA10C9519DF6057DA1F69682D28F7D0F5CCC7ECB72E3DCA2D157A4',
(from_amount / pow(10,"FROM_DECIMAL")),0))) as strd_sold,
(strd_bought - strd_sold) as net_strd_pos,
round( net_strd_pos/100000000 * 100, 2) as pcnt_supply,
count ( distinct tx_id) as swaps,
cast ( min(date_trunc('day',block_timestamp)) as date ) as first_buy,
cast ( max(date_trunc('day',block_timestamp)) as date ) as last_buy
from
osmosis.defi.fact_swaps as swaps
where
(from_currency in ('ibc/A8CA5EE328FA10C9519DF6057DA1F69682D28F7D0F5CCC7ECB72E3DCA2D157A4')
or
to_currency in ('ibc/A8CA5EE328FA10C9519DF6057DA1F69682D28F7D0F5CCC7ECB72E3DCA2D157A4'))
AND
block_timestamp between dateadd(day, -150, getdate ())
and CURRENT_TIMESTAMP()
group by trader
order by net_strd_pos DESC
Last run: about 1 year ago
50
6KB
3s