DATE | TYPE | TX_ID | WALLET | OSMO_AMOUNT | |
|---|---|---|---|---|---|
1 | 2023-07-29 00:00:00.000 | Superfluid Delegate | D9C623164A55E1F24715F35E59F52C96A2E598654595EE41FF72C1ADA49D90EE | osmo183nnun3xl7amzskn3apmnx7h6gwr427c5gr4ez | 14.426246 |
2 | 2023-07-14 00:00:00.000 | Superfluid Delegate | 86E6AC948E28B2790346030B1D1D09BE2E224683D61B582106DAC6B0C2EC9FA2 | osmo1tn8hvw96jxapay3my6qkgn05q2qcqr5f0nelkr | 216.246588 |
3 | 2023-05-25 00:00:00.000 | Superfluid Delegate | 26102D700EA5B20CF2379282BF62C159CF01B1EB4167D1D971D8019608956438 | osmo19te6prqalzfldkvj8p49wgrldex9rpmxw7mhyg | 4.700503 |
4 | 2023-12-12 00:00:00.000 | Superfluid Delegate | AC4E255E702B72B180EDF8E5B886BC6142A8CD5AA2A1450207A334CAC4E4D95C | osmo10pxrg99qpf6mtdacacq4wn6s39xy6gamqqt2lf | 247.613927 |
5 | 2023-05-30 00:00:00.000 | Superfluid Delegate | F4FC917C5268F7AF954410FDCADC917E4A158C59CAD03CF6BE04FD0126437DEA | osmo1qe72r9a6zm8z2mr4a6pkv9sgvmjaetydrg5khg | 33.628711 |
6 | 2023-03-17 00:00:00.000 | Superfluid Delegate | 6D5404DA3978FCF63E7EB433E7A8C268250C0E1C4AAEBD6FA0A0E975A10DA9E2 | osmo127km558fjep9gwzpv6t5cyr9wqjaj98ww6t963 | 79.113569 |
7 | 2023-07-31 00:00:00.000 | Superfluid Delegate | 3F693F2423AA24410DC13645B48A3BFB5A2D6DF87FED93835AD2DE0078C14D15 | osmo18qyha72aytq4wdyus9ep0h34nqy338vmqzrzrf | 3.291682 |
8 | 2023-04-07 00:00:00.000 | Superfluid Delegate | 6176DC455B5E7559EB5A5E76CF7E194F43363D1BC99A5F4809FDADFD49DF236B | osmo1xpmmmlnsxr6ujtupquwasay49vsrl5jnwsu40k | 157.512721 |
9 | 2023-12-08 00:00:00.000 | Superfluid Delegate | 178B82C3F408460BBCBEF8249ECF848B8B2DEB72EEFC58E75F06360ED25D4515 | osmo1gk737smj58de7pqhw8f5ud4kknjup2fvgcm94d | 6.651786 |
10 | 2023-12-12 00:00:00.000 | Superfluid Delegate | 74B5F9AB1289CA6A315163C7223B6C170634642220A34E349988FA6416E7591D | osmo16ch9yae5g46uvp6jz24ylukw4q53jz5letcszh | 8.051408 |
11 | 2023-04-15 00:00:00.000 | Superfluid Delegate | 621A90886914D72B7A9B2EB69A1110D5B80BAE09227A2AE14D741B91CB6B7E9E | osmo1e8ls9qgznqe4qk27c7lcmrmqtuzz89qcsw8nyu | 80.017111 |
12 | 2023-06-28 00:00:00.000 | Superfluid Delegate | 9B17AC9BF58C45AFB6EFB514D9222A8E0C5EE760D2E0B834CD7E45BE97A57794 | osmo178mjsrexnf7cqr9k4qq4dzd6x8zz4k0qt27kxf | 201.416554 |
13 | 2023-07-28 00:00:00.000 | Superfluid Delegate | 2228B9DB4C70B36533EAAA2FBB087184E233B56AA792870DFF83EF15157E5001 | osmo13lmc9dp35mlt69sj82haqflj8cx9tfzzqy7tt5 | 30.354558 |
14 | 2023-05-08 00:00:00.000 | Superfluid Delegate | 13E826278607ED6C13B2BABA6E2B9F497587010FE2B270C26A4948744C52E275 | osmo136wrasqzaplzsakzf62g0czq3jeh6wxnfuef88 | 1057.154749 |
15 | 2023-05-25 00:00:00.000 | Superfluid Delegate | E324399726CAB5EB5CC25549072675FBE5B76CBB3CC498BC9D30684C4A8032C9 | osmo19te6prqalzfldkvj8p49wgrldex9rpmxw7mhyg | 1.741411 |
16 | 2023-07-19 00:00:00.000 | Superfluid Delegate | 84C7E5CADA1EBD0D449890162074D613B2A3117C6CD80D066779BF9B66320EFE | osmo17e4luvdafaj9zf3ly7g7aqdtk7hu2ljzxm4g2h | 13.871134 |
17 | 2023-08-17 00:00:00.000 | Superfluid Delegate | 06847766A5D6A4247EE35AFA27B372FA7E52C40FF793C3993678BD1F7F95844D | osmo1cedwslds24e4d8tqsrgupmjymtk2qshvzptwyc | 171.226958 |
18 | 2023-06-25 00:00:00.000 | Superfluid Delegate | 0E9728D58E66DE1DDA5FBBE2B6A2AE9CCD808393AC81BF89F7C6D8D56A72C610 | osmo1ycuk78dy5ywdxljclnvlwdm0u5l0qsc2yue67h | 1.94026 |
19 | 2023-05-21 00:00:00.000 | Superfluid Delegate | 73A270382AA8E7E1BAFB89875D6BB38820D13E48F00F253A2DC0B3861E1D0A3D | osmo17e4luvdafaj9zf3ly7g7aqdtk7hu2ljzxm4g2h | 9.698867 |
20 | 2023-05-03 00:00:00.000 | Superfluid Delegate | 402EBA2771D924F9438A1E1A69BF180125BC8B764E60A8176751B1FBA5F965BA | osmo1dk589qfghx9pg0cz7xa9rnslk448ruw95fvzm3 | 202.765615 |
SalehOSMO_Superfluid Delegate_PRYZM_raw
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_delegate 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
split(ATTRIBUTE_VALUE,'/')[0] 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 = 'tx'
and ATTRIBUTE_KEY = 'acc_seq'
)
,lst_amount as (
select
split(ATTRIBUTE_VALUE,'uosmo')[0]/1e6 as OSMO_amount
,tx_id
,MSG_GROUP
,MSG_INDEX
,ATTRIBUTE_INDEX
from osmosis.core.fact_msg_attributes
where block_timestamp>='2023-02-01'
and TX_SUCCEEDED = true
Last run: over 1 year ago
...
113
19KB
211s