Find total number of holders for multiple coins using a single query

GraphQL API
1

I am trying to find - total number of holders for multiple coins using a single query. Also, is it possible for me to export this data on google sheet using the API?

2

Yes,please check this example: Token Holders API | Blockchain Data API (V2)

For the google sheets usecase, check this tutorial How to Track Ethereum Price in USD with Google Sheets | Blockchain Data API (V2)

3

Thanks for your response.
I have seen the example. My question: Is it possible to extract the total tokens holders for multiple tokens using a single query? Say, I have 3 tokens A, B and C. The query works well if I just have to know the total token holders for token A using the contract address. What if I want to know the total token holders for token A, B and C? Do I have to run the query separately for each token? Can I put the contract address of token A, B and C in a single query and extract the data?

{
EVM(dataset: archive, network: eth) {
TokenHolders(
date: “2023-10-21”
tokenSmartContract: “xxxxxxxxxxxxxxxxxxxxxxxxxxxx”
where: { Balance: { Amount: { gt: “0” } } }
) {
uniq(of: Holder_Address)
}
}
}

4

Currently, the query that you shared tokenSmartContract: “xxxxxxxxxxxxxxxxxxxxxxxxxxxx” supports only 1 token.

So you have to write it like this ( using alias)

{
EVM(dataset: archive, network: eth) {
A:TokenHolders(){}
B:TokenHolders(){}
C:TokenHolders(){}
}
}