papasotiriou/subgraphs

Standardized subgraphs for blockchain data

Subgraphs

This repo contains subgraphs defined using a set of standardized schemas. These subgraphs are used to extract raw blockchain data and transform them into meaningful metrics, for products and analytics. Our goal is to build a subgraph for every DeFi protocol in the space.

Contribution Guidelines

• Decide which protocol you want to build a subgraph for.
• Fork this repository.
• Add a folder under subgraphs with the name of the protocol you want to work on.
• Copy over the corresponding schema from the root folder. For example, if you are working on a yield aggregator, you should copy over schema-yield.graphql to your folder and rename it to schema.graphql. Note schema-common.graphql is used for schema design and reference, and should never be used for implementation.
• Build the subgraph within that folder. Feel free to use the reference subgraph as a reference.
• Submit a PR (pull request) to this repo after you are done. Make sure you submit your PR as a draft if it's a work-in-progress. Include a link to your deployment in your PR description.

Recommended Development Workflow

• Start with understanding the protocol. An easy start could be interacting with the protocol UI on testnets, check transaction details on Etherscan and pay attention to key events that are emitted.
• Go over the smart contracts. Identify the ones that we need to pull data from.
  • Usually each protocol has a factory contract that's responsible for tracking other contracts (e.g. Uniswap's Factory contract, Aave's Lending Pool Registry, Yearn's Registry).
  • Also a pool/vault contract that's responsible for pool level bookkeeping and transactions (e.g. Uniswap's Pair contract, Yearn's Vault contract, Aave's Lending Pool contract).
• Go over the schema and think about what data are needed from smart contract events/calls to map to the fields in each entity.
  • It's easiest to start with more granular entities and build up to aggregated data.
  • For example, usually it's easier to start writing mappings for transactions and usage metrics.
• Go over the documents in the docs folder. That should answer lots of questions you may have.
• Implement the mappings, deploy and test your data using either Hosted Service or The Graph Studio.
• For metrics calculation (e.g. revenue, fees, TVL), please refer to the README.md in the protocol's subgraph folder for methodology. There is also a broader explanation of how different fields are defined in the schema in docs/Schema.md. Feel free to reach out to me if anything isn't clear.
• We've built a handy debugging/validation dashboard for you to quickly visualize the data in your subgraph. It's deployed to subgraphs.xyz and the source code is under dashboard if you want to spin it up locally.
• Verify your subgraph against other sources and include specific links to these sources in the README. Below are some common sources:
  • Project's official analytics dashboard
  • DeFi Llama (for TVL)
  • Dune Analytics
  • TokenTerminal

For other contributing guidelines, please refer to Contributing.md

Resources

Introductory

• Learn the basics of GraphQL: https://graphql.org/learn/
• Query subgraphs using GraphQL: https://thegraph.com/docs/en/developer/graphql-api/
• Get familiar with The Graph: https://thegraph.academy/developers/
• Defining a subgraph: https://thegraph.academy/developers/defining-a-subgraph/
• Creating a subgraph: https://thegraph.com/docs/en/developer/create-subgraph-hosted/
• Deploying a subgraph using The Graph Studio: https://thegraph.com/docs/en/studio/deploy-subgraph-studio/

Intermediate

• AssemblyScript API
• Unit Test Using Matchstick
• Building a Subgraph for Sushiswap
• Building a Subgraph for Loopring
  • Using templates (dynamic data sources)
  • Indexing proxies

Advanced

• Building ambitious subgraphs (Part I): https://www.youtube.com/watch?v=4V2o5YJooOM
  • Schema design
  • Error handling
  • Interface and union types
• Building ambitious subgraphs (Part II) https://www.youtube.com/watch?v=1-8AW-lVfrA
  • Performance tips and tricks (for both mappings and queries)
• Documentation for the graph-node

Development Status

🔨 = In progress.
🛠 = Feature complete. Additional testing required.
✅ = Production-ready.

Protocol	Status	Versions †	Deployments
DEX AMM
Apeswap	✅	1.3.0 / 1.1.6 / 1.0.0
Balancer v2	🛠	1.3.0 / 1.1.2 / 1.0.0
Bancor v3	✅	1.3.0 / 1.0.0 / 1.0.0
Beethoven X	🛠	1.3.0 / 1.1.2 / 1.0.0
Curve	🛠	1.2.1 / 1.0.0 / 1.0.0
Ellipsis Finance	🛠	1.2.1 / 1.0.0 / 1.0.0
DODO v2	🔨
Honeyswap	🛠	1.3.0 / 1.0.3 / 1.0.1
MM Finance	🛠	1.3.0 / 1.0.2 / 1.0.0
Platypus Finance	✅	1.3.0 / 1.3.0 / 1.0.0
Quickswap	🛠	1.3.0 / 1.0.3 / 1.0.0
Saddle Finance	🛠	1.3.0 / 1.1.0 / 1.0.0
Solarbeam	🛠	1.3.0 / 1.1.4 / 1.0.0
SpiritSwap	🛠	1.3.0 / 1.1.4 / 1.0.0
SpookySwap	🛠	1.3.0 / 1.1.5 / 1.0.0
SushiSwap	✅	1.3.0 / 1.1.8 / 1.0.0
Trader Joe	🛠	1.3.0 / 1.1.5 / 1.0.0
Ubeswap	🛠	1.3.0 / 1.1.6 / 1.0.0
Uniswap v2	🛠	1.3.0 / 1.1.6 / 1.0.0
Uniswap v3	🛠	1.3.0 / 1.1.1 / 1.0.0
Velodrome	🔨
VVS Finance	🛠	1.3.0 / 1.1.6 / 1.0.0
Lending Protocols
Aave v2	✅	2.0.1 / 1.2.12 / 1.0.0
Aave v3	✅	2.0.1 / 1.0.3 / 1.0.0
Aurigami	🛠	2.0.1 / 1.1.3 / 1.0.0
Alpaca Finance (Lend)	🔨
Bastion Protocol	🛠	2.0.1 / 1.1.3 / 1.0.0
Banker Joe	🛠	2.0.1 / 1.1.4 / 1.0.0
BENQI	✅	2.0.1 / 1.1.3 / 1.0.0
Compound	✅	2.0.1 / 1.7.3 / 1.0.0
CREAM Finance	🛠	2.0.1 / 1.1.3 / 1.0.0
dForce	🛠	2.0.1 / 1.1.3 / 1.0.0
Euler Finance	✅	1.2.1 / 1.0.2 / 1.0.0
Geist Finance	🛠	2.0.1 / 1.0.8 / 1.0.0
Iron Bank	🛠	2.0.1 / 1.1.1 / 1.0.0
Maple Finance	✅	1.3.0 / 1.1.0 / 1.0.0
Moonwell Finance	✅	2.0.1 / 1.1.1 / 1.0.0
Notional Finance	🔨
Radiant	🔨
Rari Fuse	🛠	2.0.1 / 1.1.3 / 1.0.0
SCREAM	✅	2.0.1 / 1.1.3 / 1.0.0
TrueFi	🔨
Tectonic	✅	2.0.1 / 1.1.4 / 1.0.0
Venus Protocol	✅	2.0.1 / 1.1.4 / 1.0.0
Yeti Finance	🔨
CDPs
Abracadabra	🛠	2.0.1 / 1.2.8 / 1.0.0
Inverse Finance	🛠	1.3.0 / 1.2.2 / 1.0.0
Liquity	✅	1.3.0 / 1.1.4 / 1.0.1
MakerDAO	🛠	1.3.0 / 1.2.0 / 1.0.1
QiDAO	✅	1.3.0 / 1.1.0 / 1.0.0
Synthetix	🔨
Yield Aggregators
Alchemix	🔨
Aura	🔨
Arrakis Finance	✅	1.3.0 / 1.0.1 / 1.0.0
BadgerDAO	🛠	1.3.0 / 1.0.0 / 1.0.0
Beefy Finance	🛠	1.2.1 / 1.0.2 / 1.1.0
Belt Finance	🛠	1.2.1 / 1.0.0 / 1.0.0
Convex Finance	✅	1.3.0 / 1.2.0 / 1.0.0
Gamma Strategies	🛠	1.3.0 / 1.1.1 / 1.0.0
Harvest Finance	🔨
Rari Vaults	🛠	1.3.0 / 1.4.0 / 1.0.0
Stake DAO	🛠	1.3.0 / 1.3.0 / 1.0.0
Tokemak	🛠	1.2.1 / 1.0.0 / 1.0.0
Vesper Finance	✅	1.3.0 / 1.0.0 / 1.0.0
Yield Yak	🔨
Yearn v2	🛠	1.3.0 / 1.2.0 / 1.0.0
Others
Lido	✅	1.3.0 / 1.0.0 / 1.0.0
Rocket Pool	🔨
Tornado Cash	🔨
Governance
Fei Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
ENS Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
Hop Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
TrueFi Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
Euler Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
Silo Governor	🛠	1.0.0 / 1.0.0 / 1.0.0
Unlock Governor	🔨	1.0.0 / 1.0.0 / 1.0.0
Angle Governor	🔨	1.0.0 / 1.0.0 / 1.0.0
Code4rena Governor	🔨	1.0.0 / 1.0.0 / 1.0.0
Network Subgraph
EVM	🛠	1.1.1 / 1.1.2 / 1.0.0
Cosmos	🛠	1.1.1 / 1.1.2 / 1.0.0
NEAR	🛠	1.1.1 / 1.1.2 / 1.0.0
Arweave	🛠	1.1.1 / 1.1.2 / 1.0.0
ERC20 Subgraphs
ERC20 Tokens (2017)	🛠	1.0.0 / 1.0.0 / 1.0.0
ERC20 Tokens (2018)	🛠	1.0.0 / 1.0.0 / 1.0.0
ERC20 Tokens (2019)	🛠	1.0.0 / 1.0.0 / 1.0.0
ERC20 Tokens (2020)	🛠	1.0.0 / 1.0.0 / 1.0.0
ERC20 Tokens (2021)	🛠	1.0.0 / 1.0.0 / 1.0.0
ERC20 Tokens (2022)	🛠	1.0.0 / 1.0.0 / 1.0.0
NFT Subgraphs
OpenSea (Wyvern v1)
OpenSea (Wyvern v2)	🔨
OpenSea (Seaport)
LooksRare	🛠	1.0.0 / 1.0.0 / 1.0.0
X2Y2	🛠	1.0.0 / 1.0.0 / 1.0.0

† Versions are schema version, subgraph version, methodology version respectively