New dashboards and queries

Status

🔴

DRI

Deleted User

Team

🔮 Protocol Opportunities

Date

June 1, 2023 → July 31, 2023

Goal

📡

Cryptonet intelligence - Observability

Quarter

2023Q3

Subgoal

These are projects we’re currently working on (soon to be tracked with a db)

~~Consensus fault dashboard (Jennifer, Max, Steph) ✅ Done ✅~~

~~https://protocollabs.grafana.net/d/g1PMHEa4k/disputers?orgId=1~~

How many dispute messages do we have? https://protocollabs.grafana.net/d/g1PMHEa4k/disputers?orgId=1

Storage faults dashboard ()

‣

Current lily model doesn’t have all the data

API endpoints to track addresses from https://data.storage.market

❓ Data Q&As

‣

How many deals are slashed? What’s the probability of a deal failure (defined as a sector getting terminated before the end of deal duration)? Context is here

Time period: from 2927660 (2023-06-07) to 2406738 (2022-12-08) All deals made in that time frame: 21359418 Deals slashed in that time frame: 24458 Rate of slashed deals: 0.00114507 = 0.14507% Query:

select count(*) as all_deals, sum(mslash.slashed::int) as slashed from (select distinct on (deal_id) slash_epoch != -1 as slashed from market_deal_states where deal_id > 18009840 order by deal_id, height desc) as mslash;