thegraphR

thegraphR is a package of wrapper functions to get indexed blockchain data from The Graph Network

Authors: Brandon Kramer | License: MIT

Installation

You can install the development version of thegraphR package from GitHub with:

# install.packages("devtools")
devtools::install_github("brandonleekramer/thegraphR")

Subgraphs

• Subgraphs: Subgraphs allow users to query data on smart contracts using GraphQL. For example, to query all transactions within a single Uniswap v3 liquidity pool over the last 24 hours, Uniswap simply needs to define their schema, index the event data to create the subgraph, and then use the generated GraphQL API to query their subgraph for flexible and efficient blockchain data. With The Graph, subgraphs can also be published onchain so anyone can use them! Several other blockchain data providers, including Alchemy and Goldsky, allow you to create your own subgraphs. We opted to develop wrapper functions for The Graph specifically because that protocol provides the largest open repository of existing subgraphs to query onchain projects.
  
• Example: In this example, we use the Uniswap V3 subgraph on The Graph Network. To search for subgraphs that index other smart contracts, use Graph Explorer. The Graph also has a free hosted service, but it is set to retire in Q2 2024.
  
• Process: We develop a GraphQL query under the Playground tab, copy the Subgraph ID from the top of the page, and copy both into our R code. Next, we go to Subgraph Studio to get an API key. Note that this subgraph is deployed on The Graph on Arbitrum, which you check by validating the Network Switcher in the top-right corner of the page.
  

library("onchainR")

uniswap_query = "{ factories(first: 5) { id poolCount txCount totalVolumeUSD }}"
uniswap_subgraph = "5zvR82QoaXYFyDEKLZ9t6v9adgnptxYpKpSbxtgVENFV"
my_api_key = graph_api_key

query_subgraph(graphql_query = uniswap_query,
               subgraph_id = uniswap_subgraph,
               api_key = my_api_key)
#> $factories
#>                                           id poolCount
#> 1 0x1F98431c8aD98523631AE4a59f267346ea31F984     27089
#>                        totalVolumeUSD  txCount
#> 1 1359440939049.435110165130686261139 66484461