# How to get Holder count historical data on Base chain

**URL:** <https://community.bitquery.io/t/how-to-get-holder-count-historical-data-on-base-chain/1968>\
**Category:** GraphQL API\
**Created:** [June 21, 2024, 12:23am UTC](https://community.bitquery.io/t/how-to-get-holder-count-historical-data-on-base-chain/1968 "2024-06-21T00:23:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![fred2024](https://avatars.discourse-cdn.com/v4/letter/f/a88e4f/32.png) [@fred2024](https://community.bitquery.io/u/fred2024)\
**Post date:** [June 21, 2024, 12:23am UTC](https://community.bitquery.io/t/how-to-get-holder-count-historical-data-on-base-chain/1968/1 "2024-06-21T00:23:15Z")

</div>

Hello,

It’s easy enough to grab the historical data for a token on eth like so from the v2 API but not from [https://streaming.bitquery.io/eap](https://streaming.bitquery.io/eap). Check the code below.  
Eth query  
query MyQuery {  
EVM(dataset: archive, network: eth) {  
TokenHolders(  
date: “2024-6-18”  
tokenSmartContract: “0xdefb0b264032e4e128b00d02b3fd0aa00331237b”  
where: {Balance: {Amount: {gt: “0”}}}  
) {  
uniq(of: Holder\_Address)  
}  
}  
}

Base chain query

query MyQuery {  
EVM(dataset: archive, network: base) {  
TokenHolders(  
date: “2024-6-19”  
tokenSmartContract: “0x532f27101965dd16442E59d40670FaF5eBB142E4”  
where: {Balance: {Amount: {gt: “0”}}}  
) {  
uniq(of: Holder\_Address)  
}  
}  
}

When attempting to run this query against the Base chain using the EAP url I get the error:  
clickhouse return status 500 [500 Internal Server Error] response Code: 181. DB::Exception: Illegal FINAL. (ILLEGAL\_FINAL) (version 24.5.3.5 (official build))

Can you please clarify? Thank you!  
Fred