BLOCK_TIMESTAMP | MULTISIG | OWNER | SERVICEID | |
|---|---|---|---|---|
1 | 2024-08-14 09:48:55.000 | 0xdab47894968c773be2b2205332e17f5599bc3634 | 0xf9fc6c6eb50595d7c80cd548d1c6ba17bb1a0052 | 576 |
2 | 2024-08-12 12:54:30.000 | 0xe27ab203204bb40d8853b4b576950ae4b407de3a | 0x5101bd202c02fcee0a1467252954c6d8cb176183 | 559 |
3 | 2024-08-14 13:24:00.000 | 0x20a55f64186b467fa67df63c2b8d2e0d84ecdaa4 | 0x17799ab92236c8832a5704deb4d6aaf5aef3251e | 578 |
4 | 2024-08-08 17:41:05.000 | 0x11d3628a251761404a86919297a7ccf6081232a2 | 0x0eb8d8b9f1245469f8aea97d423bcfd04d6fdf42 | 490 |
Flipside TeamCurrently staked services on Alpha stage
Updated 2025-03-31
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
›
⌄
--- staking part
with tb1 as (select
BLOCK_TIMESTAMP,
tx_hash,
MULTISIG_ADDRESS as multisig,
OWNER_ADDRESS as owner,
SERVICE_ID as serviceId,
row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no
from crosschain.olas.ez_service_staking
where PROGRAM_NAME = 'Alpha'
and EVENT_NAME = 'ServiceStaked'
),
tb2 as (select
*
from tb1
where r_no = 1),
---------------------------------------------------------------------------
--- unstaking part
tb3 as (select
BLOCK_TIMESTAMP,
tx_hash,
MULTISIG_ADDRESS as multisig,
OWNER_ADDRESS as owner,
SERVICE_ID as serviceId,
row_number() OVER (partition BY serviceId order by BLOCK_TIMESTAMP desc) as r_no
from crosschain.olas.ez_service_staking
where PROGRAM_NAME = 'Alpha'
and EVENT_NAME = 'ServiceUnstaked'
),
tb4 as (select
*
from tb3
where r_no = 1),
Last run: 15 days ago
4
489B
48s