# Messari December 2023 Update

**URL:** <https://forum.thegraph.com/t/messari-december-2023-update/4945>\
**Category:** Core Team Updates\
**Tags:** messari\
**Created:** [December 9, 2023, 10:13pm UTC](https://forum.thegraph.com/t/messari-december-2023-update/4945 "2023-12-09T22:13:44Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![vincent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.thegraph.com/vincent/32/1717_2.png) [@vincent](https://forum.thegraph.com/u/vincent)\
**Post date:** [December 9, 2023, 10:13pm UTC](https://forum.thegraph.com/t/messari-december-2023-update/4945/1 "2023-12-09T22:13:44Z")

</div>

## 👩‍🚀 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: [https://substreams.streamingfast.io/tutorials/substreams-sql](https://substreams.streamingfast.io/tutorials/substreams-sql).

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.

## 🎉 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`

## 🚀 Looking ahead (upcoming priorities)

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