DATE | TYPE | TX_ID | WALLET | OSMO_AMOUNT | |
|---|---|---|---|---|---|
1 | 2023-11-29 00:00:00.000 | Undelegate | BABC12055B0A1B6AF36FCAA3F7A8BFB674DEDD418122EAF813299F43AD1B1DD2 | osmo1rg37lmmxhaam6scxxs2x94e2jxcpy9trxq925r | -3.449665 |
2 | 2023-12-08 00:00:00.000 | Undelegate | 7A7F4A0E60CB4A544F25F163220984144280D4584E28BCC611FE7F092125777E | osmo104x990p8wlt02r8ukflskx0d44fvzppp6xgw9y | -1 |
3 | 2024-01-17 00:00:00.000 | Undelegate | 057D9EF558DBFEBD18F5D6CD1AEEA33D1DA450744CA70CB776B3E67F7BBDD673 | osmo147knsxsfthp3hwen866n5rhwcwcfvmyhxwwz4y | -50 |
4 | 2023-07-08 00:00:00.000 | Undelegate | B908B28FE958C8BFCCF5E601B945C42845E91DB12137375FB6BA18818724BB25 | osmo130l49shgpl6h6q2u88k5afnhd982tgrrcp9ucy | -200 |
5 | 2024-02-08 00:00:00.000 | Undelegate | 5458BAFD9C1DEB5D0B58535031EBA8743AFBAEBCAA5F420F9EDA4F9A0646F988 | osmo14vln6nfmr3pvt80mx56nlsqp0unnwuccfvc2dc | -37.5 |
6 | 2024-01-27 00:00:00.000 | Undelegate | EFFDA69B2AC086ED0FFA752A80E4384D4DC34455035001572F3835C58715C515 | osmo1e49cvjgtf0anp0gpdqhs3tzg24mcgse03wpln3 | -500 |
7 | 2023-03-22 00:00:00.000 | Undelegate | E276E09E748DC4CF4530DA833614DABCDFDBC42FD1BF71574D7FB43665D89C0C | osmo1sa7kvnn4t5f9e3law668x39ymhjwsktv9r3qmu | -85.815943 |
8 | 2024-01-17 00:00:00.000 | Undelegate | B82C70BFC096BC0163699CA125334FEC9D5C98D881FD1B46135D21E369B8C1E1 | osmo154rdq87nejq44jf7jrlxzkdqsp9y29v4tuelt5 | -50 |
9 | 2023-07-17 00:00:00.000 | Undelegate | E045B32660428503C632A22DE554BB3466D5755BD293975064358ED30C33E945 | osmo1x7mzgz27em7auhqrqx2pgkq3gv0wma9jlsulcl | -85.05 |
10 | 2024-02-07 00:00:00.000 | Undelegate | 477CB928AA771C189E0ECEA6160634FFD45E8158564C069C28E281350752A42B | osmo1s6tcrj5kn8qmep459yt00v8l7jc7n0gshkk544 | -1 |
11 | 2024-02-14 00:00:00.000 | Undelegate | 424F3C52AD593508A5904B8F4A676085ECCD9537CAC7B5F9BFBAF4075670712A | osmo1vhxnux2dx8mr8p80mq0xr7cj486xsjlevh06hk | -54 |
12 | 2024-02-14 00:00:00.000 | Undelegate | 8B658303010E05F272F2520C2FD0707644DA3259FAAF1930137F67E8608CEF0B | osmo1tuflmasg9d0flsfay66ducs044ajzckkk0uy7w | -90 |
13 | 2023-05-17 00:00:00.000 | Undelegate | F1D206D5F671AA7A0FC538DA41F18E3076EE0115BC0EA1452E7B1DD2374E7D5D | osmo1axja43hcfyphtradwscxydzpznc3q0c5yt8q2g | -1021.455496 |
14 | 2024-01-05 00:00:00.000 | Undelegate | 9F718188ABC31337F5C14F9D38BC5486D5360828833742F12C7ADBFCE0875B53 | osmo16pep5ecfqg4ncuhdrkccncfrjl5fxwvl0pla0t | -200 |
15 | 2023-12-12 00:00:00.000 | Undelegate | 52B45874274F37719C49D6E9C0C99B68422209CB2248C2DF7F3AD59E174030BA | osmo1uqwpnds3t75yuy49lwu4jqrjdde3jjlfuccllk | -64 |
16 | 2024-02-14 00:00:00.000 | Undelegate | A86C760DB75D3B52DD3913B49B22306160EF7BB6DE8AABDD6190E6C812132C1B | osmo1348gg2cdsw3duugwy5eaqwjyscechclufmly2d | -102 |
17 | 2024-02-07 00:00:00.000 | Undelegate | E5038FA05CA8A12409FA3831EC4FFEA6B377B660D21E48B8599667CF8E9AA7CA | osmo124u7l7hfx4s9yf09t60vvkydvleq87h5lhjshe | -500 |
18 | 2024-02-15 00:00:00.000 | Undelegate | 5C41A4D4D0F0081359AF3330590129CF000FA2EDF4DA00AB49B888593C88414E | osmo1svuskrcjc76a24lr00qdcyarqw9anf59law76j | -101.040045 |
19 | 2024-01-27 00:00:00.000 | Undelegate | A99F5025B495F36EED4F140C91F2F1EC4C19EBC7BA322EA9FBB8DFF9CAFAE83F | osmo1ksu649pehwwhjp534ev5qp4ku96kzck8dkadun | -651.388323 |
20 | 2024-02-02 00:00:00.000 | Undelegate | 4768C7020D051A282FBB2B3E90854D218659B8169164788FE561EF69FC84874B | osmo104usf7kksg6htpyvkk0xrlxm3jryuz68eywkud | -48 |
SalehOSMO_undelegate_PRYZM_raw1
Updated 2024-02-17
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
›
⌄
with lst_undelegate as (
with lst_cond1_for_wallet as (
select
tx_id
,MSG_INDEX
from osmosis.core.fact_msg_attributes
where block_timestamp>='2023-02-01'
and TX_SUCCEEDED = true
and MSG_TYPE = 'message'
and ATTRIBUTE_VALUE = 'staking'
and ATTRIBUTE_KEY ='module'
)
,lst_delegator as (
select
ATTRIBUTE_VALUE as wallet
,tx_id
,MSG_GROUP
,MSG_INDEX
from osmosis.core.fact_msg_attributes
join lst_cond1_for_wallet using(tx_id,MSG_INDEX)
where block_timestamp>='2023-02-01'
and TX_SUCCEEDED = true
and MSG_TYPE = 'message'
and ATTRIBUTE_KEY = 'sender'
)
,lst_amount as (
select
split(ATTRIBUTE_VALUE,'uosmo')[0]/1e6 as OSMO_amount
,tx_id
,MSG_GROUP
,MSG_INDEX
from osmosis.core.fact_msg_attributes
where block_timestamp>='2023-02-01'
and TX_SUCCEEDED = true
and MSG_TYPE = 'unbond'
and ATTRIBUTE_KEY = 'amount'
Last run: over 1 year ago
...
3947
619KB
319s