Uniswap v3 Subgraph Consultant

Job ID: 39964201

Budget: $1,500 – $3,000 USD

I am refining a custom subgraph on The Graph for Uniswap v3 and need an experienced hand to guide the process rather than to build everything from scratch. The goal is to be certain the architecture, mappings, and queries will scale before my team invests further development time.

Scope of the advice
• Indexing coverage must include: transactions & swaps, liquidity positions, pool statistics, plus both the overall TVL in USD and the TVL of in-range positions only.
• I already have contract ABIs and a draft schema; what I need is a critical review of the design, suggestions for AssemblyScript mapping optimisations, and pointers on how best to calculate the two TVL metrics without bloating the node.
• Performance tuning tips around entity ordering, handling large block ranges, and crafting GraphQL queries for dashboards are essential.

Deliverables
1. A written technical report (or well-commented code snippets) that shows the recommended schema changes, mapping logic, and sample queries.
2. One live video or voice session (recorded for later reference) where you walk through the recommendations and answer open questions.
3. Short follow-up support in chat for any clarification as we implement.

If you have deployed or audited subgraphs for Uniswap v3 before—and can back that up with repos or thegraph.com links—your guidance will be especially valuable.