Risks, problems, help

• Substreams SQL
  • Plans for contract states? We will need that in lots of places.
  • Uniswap v3: cannot derive TVL as the events do not have balance data. We will need contract call data as well.
  • Uniswap v2: can build TVL and volume for a single pool. Need support for dynamic data sources for multiple pools.
  • Balancer: we are blocked on array support in events. Need that for TVL calculation.

Achievements

• Substreams:SQL
• SQL/DBT experiments (5 in total 🎉)
• Refactoring/standardizing the DBT models for code reuse
• Maintenance, upgrade, fixes

Active

• Substreams:SQL
  • Uniswap v2 PR pending:
    • https://github.com/messari/substreams/pull/154/files
    • https://srv.streamingfast.io/fb95f530/pgweb/
  • Uniswap v3
  • Balancer
• SQL/DBT experiments
  • Curve
  • Compound v3
  • MakerDAO

Next steps

• More SQL/DBT Models