how to get the reserves of all coin pairs at once on pancakeSwap

Question

I am trying to query the pancakeSwap token pair contract for the reserves, and since I am trying to get it for 10000 tokens at a single time.

My current solution is to basically loop over the 10000 tokens and query each smart contract of that coin pair to get the reserves which happen to be very consuming in physical resources.

Is there a way to get all the reserves in a single smart contract query?

Answer 1

Here's an option for using in future... it currently looks like there's a failure in compiling the dataset, so it's only partially being returned.

You could use the PancakeSwap SubGraph: https://thegraph.com/explorer/subgraph/bscnodes/pancakeswap

Here's the query:

{
  pairs(orderDirection: asc) {
    id
    reserve0
    reserve1
    reserveETH
    reserveUSD
  }
}