DATE | ONI1_UPGRADE | ONI2_UPGRADE | ONI3_UPGRADE | ONI4_UPGRADE | ONI5_UPGRADE | MRZ19_UPGRADE | MRZ20_UPGRADE | MUD1_UPGRADE | MUD2_UPGRADE | MUD3_UPGRADE | MUD4_UPGRADE | MUD5_UPGRADE | MRZ4_UPGRADE | MRZ5_UPGRADE | UST1_UPGRADE | UST2_UPGRADE | UST3_UPGRADE | UST4_UPGRADE | UST5_UPGRADE | MRZ21_UPGRADE | MRZ22_UPGRADE | ONI1_TIER | ONI2_TIER | ONI3_TIER | ONI4_TIER | ONI5_TIER | MRZ19_TIER | MRZ20_TIER | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2025-03-15 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
2 | 2025-03-14 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
3 | 2025-03-13 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
4 | 2025-03-12 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
5 | 2025-03-11 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
6 | 2025-03-10 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
7 | 2025-03-20 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
8 | 2025-03-19 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
9 | 2025-03-18 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
10 | 2025-03-17 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
11 | 2025-03-16 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
12 | 2025-03-09 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
13 | 2025-03-08 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
14 | 2025-03-07 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
15 | 2025-03-06 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
16 | 2025-03-05 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
17 | 2025-04-01 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
18 | 2025-03-31 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
19 | 2025-03-30 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
20 | 2025-03-29 00:00:00.000 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 5 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 1 | 1 | 3 | 1 | 4 | 5 |
AephiaStarbases tier level
Updated 2025-04-01
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
›
⌄
WITH upgrade AS (
SELECT
date_trunc('day', block_timestamp) as date
---ONI---
,6 as ONI1_upgrade
,count(CASE when instruction:accounts[1] = 'C4gwAfZX2itwyLQGjHQmM5ZEEbvJ73VdMYRARMggHTfX'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as ONI2_upgrade
,count(CASE when instruction:accounts[1] = 'EtepVfgCfyKAJg4B9QYG5BeSW3oRzMsKPHz7Ld1Hsa5V'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as ONI3_upgrade
,count(CASE when instruction:accounts[1] = 'GE7Ud3sT16M1NC7xW9YYzSB9dnPWvExgWAZYzxshwgim'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as ONI4_upgrade
,count(CASE when instruction:accounts[1] = 'EcL56x62fJ4dWiDJSRwSmhgWjTEz73JKSwXybPDh35ME'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as ONI5_upgrade
,count(CASE when instruction:accounts[1] = 'HaTpXV4UbfzVNdRVvAfyka76h7CK5CeB9JZuRWataFCg'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as MRZ19_upgrade
,count(CASE when instruction:accounts[1] = 'HctDXX6qb77pcm8CAaWQLd2dTFPAF9wqJ6NNgmdAerFX'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as MRZ20_upgrade
---MUD---
,6 as MUD1_upgrade
,count(CASE when instruction:accounts[1] = '7zomNZp3Z1sjAhNqrvPoWcmshXFHGgUu7FLJrqQtUNkG'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as MUD2_upgrade
,count(CASE when instruction:accounts[1] = '6pkHA9CPF6xm49TLVN9iJuHn5QF7V2kMvpBFyJBWsHrn'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as MUD3_upgrade
,count(CASE when instruction:accounts[1] = 'NxvHJR6dQz8KB7WRdwQnHVJphqQ7FEat7VW3rsg5qiY'
AND (instruction:accounts[4] = 'C7wUJ3TCAAXFTsSyeR4ga4Wwbh78VMvgywTJ7qxJtLZj' OR instruction:accounts[4] = 'Dp4wC9k1SLxHKXHvMmEny2bDsfttaZoTkEZ5ofb3wUTN' OR instruction:accounts[4] = 'Ppr4dXWD2uMe4pJtpcozMZzGiBCgtub5PtNNy8PGbK6' OR instruction:accounts[4] = '3Yzebx7aLvMF3dJWLevLA6PXqVx5Zy2dMADsbKHGJ1Q9')
then tx_id end) as MUD4_upgrade
,count(CASE when instruction:accounts[1] = 'HVh1yZFxpSXwtrguy8CNHtBQc91uC51xCqYuTAVj64N7'
Last run: about 1 month ago
...
364
30KB
27s