Risks, problems, help

• Substreams powered subgraphs sync speed (7 days vs 2 hours) (being looked at)
• Subgraph failed with non-deterministic error: Store error: internal constraint violated: duplicate entity in result set, retry_delay_s: 255, attempt: 1 (need to debug further from our end and come back with more info)

Achievements

• 92 subgraphs built, 68 fully QAed
  • Messari standardized subgraph supporting Spark Protocol’s front-end since launch on Day 1 🎉
• Substreams
• Maintenance, upgrade, fixes

Active

• Substreams work
  • Uniswap v2
  • Uniswap v3
  • Parametrized erc20-holders & subgraph(s)
  • ABI codegen → ABI events to proto
  • Synthetix Staking Balances
• 18 subgraphs under active development
  • Camelot V2
  • Mux Network
  • AAVEv2 (and forks) Upgrade to latest schema
  • Mummy Finance
  • Polygon Bridge
  • Synapse
  • Odos
  • Across V2
  • Orbit bridge
  • Reactor Fusion
  • Thena Fusion
  • Kwenta - QA
  • Vela Exchange - QA
  • Arbitrum Bridge - QA
  • Gains network - QA
  • Satellite (Axelar) - QA
  • Morpho - QA
  • Hop - QA
• Infra & Tooling
  • Subgraph Monitor Refactor

Next steps

• Moar subgraphs/substreams
  • Solana network metrics & top protocols
  • More protocols TBD
• Gather substreams pains and feedback
• Substreams tooling
  • Pricing
  • CI: Versioning, auto-releases, etc. Contribution docs
• Subgraph data quality
  • Monitoring improvements, logging standardization & alerting, methodology revisions