Messari December 2023 Update

:woman_astronaut: Summary

A couple more new subgraphs deployed with a lot of fixes merged in.

We’ve completed our second SQL-based protocol transformations and are in the process of onboarding to Substreams:SQL, which will allow the SQL/DBT models we build to be deployed as a substreams deployable unit. See more details here:

The initial onboarding experience has been very smooth. Currently one missing piece is dynamic data source which is required for contracts spawned by factories. After that’s supported we will be able to convert our Uniswap v2 DBT models into a Substreams:SQL deployable unit.

:tada: Looking back (what was delivered)

  • Subgraphs
    • Production ready (new)
      • Orbit bridge
      • Hifi DAO (governance)
    • Bug fixes
      • Eigenlayer: create and fill in snapshots for days/hours with no events
      • Aave v2 forks: missing liquidation data
      • Multichain: ignore mispriced tokens on Avalanche
      • Hop Protocol: add config for Linea, update reward tokens
      • Convex Finance: add mispriced factory pools’ LP tokens to CurveFactoryPoolOverride
      • Portal: blacklist mispriced token ESMPTOKIN on polygon
      • Perp Futures SDK: fix activeLiquidators count / upgrade Kwenta to latest schema
  • SQL-based protocol transformations
    • Aave v2 completed
    • Onboarding to Substreams:SQL

:rocket: Looking ahead (upcoming priorities)

  • Subgraph maintenance
  • SQL-based protocol transformations
    • Curve
    • Compound v2
    • MakerDAO
    • Uniswap v3
    • Balancer
    • Aave v3