Skip to main content

Python package to query DeFi data from several The Graph subgraphs

Project description


DeFi Crawler Python library

Table of Contents


This library allows to get DeFi data from several protocols in a structured and standard way. This data comes from different subgraphs displayed in The Graph protocol


Python 3.6


pip install deficrawler


To get data from a protocol, it's needed to create an instance of the protocol with the name, version and blockchain where the protocols exists, the supported protocols can be found in supported protocols section. And the entities for the protocols with the field types in the entities folder

To get data from Lending protocols

# Instanciate the protocol with the name, version and chain
from deficrawler import Lending

aave = Lending(protocol="Aave", chain="Ethereum", version=2)
aave_polygon = Lending(protocol="Aave", chain="Polygon", version=2)
compound = Lending(protocol="Compound", chain="Ethereum", version=2)
cream = Lending(protocol="Cream", chain="Ethereum", version=2)
cream_bsc = Lending(protocol="Cream", chain="bsc", version=2)

# Not all the protocols has the same available events to get data, to know which entities are supported for each protocol:

## For each different entity, data can be retrieved in a specific time range.
compound.get_data_from_date_range(start_date, end_date, "borrow")

# To get the all the users of a protocol

# And the user positions 

To get data from Dex protocols

# Instanciate the protocol with the name, version and chain
from deficrawler import Dex

uniswap = Dex(protocol="Uniswap", chain="Ethereum", version=2)
balancer = Dex(protocol="Balancer", chain="Ethereum", version=1)
bancor = Dex("Bancor", chain="Ethereum", version=1)
shushi = Dex("SushiSwap", chain="Ethereum", version=1)

# Not all the protocols has the same available events to get data, to know which entities are supported for each protocol:

## For each different entity, data can be retrieved in a specific time range.
uniswap.get_data_from_date_range(start_date_amm, end_date_amm, "swap")

# To get the all the pools of a protocol

To get prices from the oracles it's needed to instanciate an oracle object and call the functions.

# Instanciate the oracle with the name, version and chain
from deficrawler import Oracle

chainlink = Oracle(protocol="chainlink", version=1, chain="Ethereum")

#Get all the available pairs to get the data

#Get the price for a specific pair in a time range
chainlink.get_price_from_date_range(from_date=start_date, to_date=end_date, pair="ETH/USD")



Name Type Version Chain
Aave Lending 2 Ethereum
Aave Lending 2 Polygon
Aave Lending 2 Avalanche
Compound Lending 2 Ethereum
Cream Lending 2 Ethereum
Cream Lending 2 BSC
Cream Lending 2 Polygon
Cream Lending 2 Arbitrum
Cream Lending 2 Avalance
Cream Lending 2 Fantom
Kashi Lending 1 Ethereum
Kashi Lending 1 Polygon
Kashi Lending 1 xDai
Kashi Lending 1 fantom
Uniswap Dexes 2 Ethereum
Uniswap Dexes 3 Ethereum
Uniswap Dexes 3 Optimism
Balancer Dexes 2 Ethereum
Balancer Dexes 2 Arbitrum
Balancer Dexes 2 Polygon
Bancor Dexes 1 Ethereum
SushiSwap Dexes 1 Ethereum
SushiSwap Dexes 1 BSC
SushiSwap Dexes 1 Polygon
SushiSwap Dexes 1 Fantom
SushiSwap Dexes 1 Celo
Dodoex Dexes 2 Ethereum
Dodoex Dexes 2 Polygon
Dodoex Dexes 2 BSC
Dodoex Dexes 2 Arbitrum
Ubeswap Dexes 1 Celo
Pancakeswap Dexes 2 BSC
Pangolin Dexes 1 Avalanche
Traderjoe Dexes 1 Avalanche


Name Type Version Chain
Chainlink Oracle 1 Ethereum


Tests are creatd using Pytest library. To run the tests

pytest -v 


To run the examples run

python3 docs/ 


If you want to add a new protocol to be supported or a new entity to retrive data, create a PR with the new configuration of the protocol and the unit/integration tests of this new feature.

To add a new protocol, create a new json config file in the config folder, with the struture protocolname-version.json. Inside this configuration file must be the following sections:


This section specifies the global configuration of the protocol. The required fields are

  • Name: Protocol name.
  • Type: Protocol type (Borrowing lending)
  • Version: Version of the protcol
  • Enpoint: Subgrapn endpoint to send the http request to get the data. If the protocols exists on more than one chain, several enpoints can be provided


  "protocol": {
    "name": "AAVE",
    "type": "Lending",
    "version": 2,
    "endpoint": {
      "ethereum": "",
      "polygon": ""

After this section the supported entities should be specified. Each entity has three different sections inside of them.

  • Entity: The entity contains the fields to create a common entity from a shared type of event of different protocols (borrow, swap, deposit...). The entity starts with the name that will be applied to this specific event across all the protocols. Then should be a field for each attribute that will be contained in the entity, and each field shoud have an array, with the path to find this element in the corresponding subpgraph, these fields will be used to create the query. As example for borrow entity in Aave:
    "borrow": {
      "attributes": {
        "user": [
        "token": [
        "amount": [
        "timestamp": [
  • Query:: Each query in each protocol can be named different, to allow create the query dynamically, the query name should be specified and the field to order by if will be more that one batch to retrive. In this section also can be specified, additional fields to get data from the subgraph that will be needed to apply transformations, but will not be part of the output itself. As example for Aave we need to get the decimals for the token to divide the amount, but the decimals are not part of the entity. As example
        "query": {
          "extra_fields": {
            "decimals": [
          "name": "borrows",
          "params": {
            "orderBy": "timestamp"
  • Tranformations: This section specified the transformations that should be applied to the fields (if any transformation should be applied). Here we can specify the field of the common entity (the output) that needs to be transform, and the function that will be applied. This funtion will be call dinamically in the transformation phase. As example:
        "transformations": {
          "amount": "decimals",


Copyright 2020 Keyko GmbH.

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

deficrawler-0.4.0.tar.gz (40.1 kB view hashes)

Uploaded source

Built Distribution

deficrawler-0.4.0-py3-none-any.whl (43.6 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page