get_all_pairs_thegraph.py

import requests
import json

def get_query(skip):
    query = '''
    {
       pairs(first: 1000, skip: $skip) { 
        id
        token0 {
          id
          symbol
          decimals
        }
        token1 {
          id
          symbol
          decimals
        }
        reserve0
        reserve1
       }
    }'''
    return query.replace('$skip', str(skip))
url = "https://api.thegraph.com/subgraphs/name/uniswap/uniswap-v2"

from gql import gql, Client
# from gql.transport.aiohttp import AIOHTTPTransport
from gql.transport.requests import RequestsHTTPTransport

# transport = AIOHTTPTransport(url="https://countries.trevorblades.com/")
transport = RequestsHTTPTransport(url=url)
client = Client(transport=transport, fetch_schema_from_transport=True)

all_pairs = []
idx = 0
while idx < 29200:
    query = gql(get_query(idx))
    result = client.execute(query)
    all_pairs.extend(result['pairs'])
    idx += 1000 
    print('idx:', idx)
    with open('data/pairs.json', 'w') as f:
        json.dump(all_pairs, f)