All questions on the token holders from StackOverflow answered
Published: 2023-10-30 12:27:15

## How to get Ethereum token holders' amount history and analysis daily
https://stackoverflow.com/questions/68980485/how-to-get-ethereum-token-holders-amount-history-and-analysis-daily

You can do a complete analysis of token holders with B[itquery's Token Holder API](https://docs.bitquery.io/docs/examples/token-holders/token-holder-api/). You can get top holders for a Token for example, by simply writing a click-select query. The below example gets the top holders of Mutant Ape Yacht Club: MAYC Token on 22nd October 2023.

```
{
  EVM(dataset: archive, network: eth) {
    TokenHolders(
      date: "2023-10-22"
      tokenSmartContract: "0x60E4d786628Fea6478F785A6d7e704777c86a7c6"
      limit: {count: 10}
      orderBy: {descending: Balance_Amount}
    ) {
      Holder {
        Address
      }
      Balance {
        Amount
      }
    }
  }
}
```


## Getting a list of ERC20 token holders in solidity
https://stackoverflow.com/questions/52601289/getting-a-list-of-erc20-token-holders-in-solidity

You could try using an on-chain indexer that has token holder data.

Bitquery, for example, has an API for token holders that provides information on holders, their holdings, top holders, and other details.

Here's an example. This query gives you top holders for USDT
You can run it [here][1].
```
query MyQuery {
  EVM(dataset: archive, network: eth) {
    TokenHolders(
      date: "2023-10-29"
      tokenSmartContract: "0xdAC17F958D2ee523a2206206994597C13D831ec7"
      orderBy: {descending: Balance_Amount}
      limit: {count: 10}
    ) {
      Balance {
        Amount
      }
      Holder {
        Address
      }
      Currency {
        Name
      }
    }
  }
}
```
[![enter image description here][2]][2]


  [1]: https://ide.bitquery.io/USDT-Top-10-Holder
  [2]: https://i.stack.imgur.com/cXP0L.png

## Token Holder History By Date Query
https://stackoverflow.com/questions/77161497/token-holder-history-by-date-query-in-dune-analytics

## Get token balance as of x Date

https://stackoverflow.com/questions/48665783/get-token-balance-as-of-x-date

## How to get transfer with token USDT of address balance in web3 python in ethereum
https://stackoverflow.com/questions/76753381/how-to-get-transfer-with-token-usdt-of-address-balance-in-web3-python-in-ethereu/77388621#77388621
You can use a blockchain data indexer to get it without contacting the ABI.

[Bitquery][1] has a transfers API and token holders API. For the address you have mentioned, you can get all transfers from this address with this query. There is an auto-code generator that will generate the code in Python for you. 
[![enter image description here][2]][2]

```
{
  ethereum(network: ethereum) {
    transfers(
      options: {desc: "block.height", limit: 10, offset: 0}
      sender: {is: "0x28C6c06298d514Db089934071355E5743bf21d60"}
      amount: {gt: 0}
    ) {
      block {
        timestamp {
          time(format: "%Y-%m-%d %H:%M:%S")
        }
        height
      }
      sender {
        address
        annotation
      }
      receiver {
        address
        annotation
      }
      currency {
        address
        symbol
      }
      amount
      amount_usd: amount(in: USD)
      transaction {
        hash
      }
      external
    }
  }
}
```
run it [here][3]


  [1]: https://bitquery.io/
  [2]: https://i.stack.imgur.com/2OLBo.png
  [3]: https://ide.bitquery.io/Transfers-from-an-address