Messari November 2023 Update

:woman_astronaut: Summary

As a part of the World of Data Services, we’ve been looking at other ways to index subgraph data. In particular, using SQL and OLAP database (or Data Warehouse) to index analytics data (things like aggregations for example). We are seeing some very promising results in our experiments on Uniswap v2 (more details below), and we will continue to explore in that direction.

:tada: Looking back (what was delivered)

  • Subgraphs
    • 1 new subgraph are prod ready
      • Eigenlayer
    • Various bug fixes
      • GMX: update subtractArrays method to handle uneven arrays
      • Level Finance: fix negative balance error
    • Schema updates
      • Perps Schema: allow multiple liquidations per Position
  • SQL-based protocol transformations
    • Uniswap v2: we’ve replicated our Uniswap v2 subgraph logic in SQL 1-to-1 with our standardized DEX subgraph schema, and have seen incredible improvements to the indexing speed. This is an area where we will be investing more resource over the next couple months and do more experiments understanding the potentials and limitations of the SQL/DWH-based approach.

:rocket: Looking ahead (upcoming priorities)

  • Subgraph maintenance
  • SQL experiments
    • Uniswap v3
    • Balancer
    • Curve
    • Aave v3