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

**URL:** <https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961>\
**Category:** GraphQL API\
**Created:** [June 13, 2024, 1:42pm UTC](https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961 "2024-06-13T13:42:47Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![anand](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@anand](https://community.bitquery.io/u/anand)\
**Post date:** [June 13, 2024, 1:42pm UTC](https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961/1 "2024-06-13T13:42:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)\
**Post date:** [June 14, 2024, 9:01am UTC](https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961/2 "2024-06-14T09:01:11Z")

</div>

Yes,please check this example: [Token Holders API | Blockchain Data API (V2)](https://docs.bitquery.io/docs/examples/token-holders/token-holder-api/#common-token-holders-of-two-tokens)

For the google sheets usecase, check this tutorial [How to Track Ethereum Price in USD with Google Sheets | Blockchain Data API (V2)](https://docs.bitquery.io/docs/usecases/real-time-historical-ethereum-price-excel-google-sheets/)

---

<div class="post-metadata">

**Author:** ![anand](https://avatars.discourse-cdn.com/v4/letter/a/ecd19e/32.png) [@anand](https://community.bitquery.io/u/anand)\
**Post date:** [June 16, 2024, 5:56am UTC](https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961/3 "2024-06-16T05:56:07Z")

</div>

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)  
}  
}  
}

---

<div class="post-metadata">

**Author:** ![Divya](https://avatars.discourse-cdn.com/v4/letter/d/13edae/32.png) [@Divya](https://community.bitquery.io/u/Divya)\
**Post date:** [June 17, 2024, 6:38am UTC](https://community.bitquery.io/t/find-total-number-of-holders-for-multiple-coins-using-a-single-query/1961/4 "2024-06-17T06:38:07Z")

</div>

> [@anand](#):
>
> tokenSmartContract: “xxxxxxxxxxxxxxxxxxxxxxxxxxxx”

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

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

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

```