kekec holders
Returns one token holder on Ethereum, where holder address is not 0x and balance amount is above 0: last date, count, sum of balance amount, gini of balance amount, nakamoto of balance amount, currency name, currency symbol and chain ID.
What it returns
- last date
- count
- sum of balance amount
- gini of balance amount
- nakamoto of balance amount
- currency name
- currency symbol
- chain ID
Filters
- holder address is not 0x
- balance amount is above 0
The query
query ($network: evm_network, $from: String!, $date_middle: String!, $till: String!, $token: String!) {
EVM(network: $network, dataset: archive) {
date1: TokenHolders(
tokenSmartContract: $token
date: $from
where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
) {
BalanceUpdate {
LastDate(maximum: BalanceUpdate_LastDate)
}
count
supply: sum(of: Balance_Amount)
gini(of: Balance_Amount)
nakamoto(of: Balance_Amount)
Currency {
Name: Name(maximum: BalanceUpdate_LastDate)
Symbol: Symbol(maximum: BalanceUpdate_LastDate)
}
}
date2: TokenHolders(
tokenSmartContract: $token
date: $date_middle
where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
) {
BalanceUpdate {
LastDate(maximum: BalanceUpdate_LastDate)
}
count
supply: sum(of: Balance_Amount)
gini(of: Balance_Amount)
nakamoto(of: Balance_Amount)
Currency {
Name: Name(maximum: BalanceUpdate_LastDate)
Symbol: Symbol(maximum: BalanceUpdate_LastDate)
}
}
date3: TokenHolders(
tokenSmartContract: $token
date: $till
where: {Balance: {Amount: {gt: "0"}}, Holder: {Address: {not: "0x"}}}
) {
BalanceUpdate {
LastDate(maximum: BalanceUpdate_LastDate)
}
count
supply: sum(of: Balance_Amount)
gini(of: Balance_Amount)
nakamoto(of: Balance_Amount)
Currency {
Name: Name(maximum: BalanceUpdate_LastDate)
Symbol: Symbol(maximum: BalanceUpdate_LastDate)
}
}
Blocks(limit: {count: 1}) {
ChainId
}
}
}
Variables
{
"network": "eth",
"from": "2023-10-27",
"date_middle": "2024-02-08",
"till": "2024-05-23",
"token": "0x8C7AC134ED985367EADC6F727d79E8295E11435c",
"till_now": "2024-05-23",
"dateFormat": "%Y-%m"
}
Similar queries
- USDT token holder distribution · Ethereum · TokenHolders
- EVM TokenHolders bat token · Ethereum · TokenHolders
- Check USDC on 16 May · Ethereum · TokenHolders
- tokens owned by an address #2 · Ethereum · TokenHolders
- Telcoin holders · Ethereum · TokenHolders