# Fetching all 30k market cap crossed tokens on solana

**URL:** <https://community.bitquery.io/t/fetching-all-30k-market-cap-crossed-tokens-on-solana/2247>\
**Category:** GraphQL API\
**Created:** [January 27, 2025, 4:26am UTC](https://community.bitquery.io/t/fetching-all-30k-market-cap-crossed-tokens-on-solana/2247 "2025-01-27T04:26:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![akechi0523](https://avatars.discourse-cdn.com/v4/letter/a/c77e96/32.png) [@akechi0523](https://community.bitquery.io/u/akechi0523)\
**Post date:** [January 27, 2025, 4:26am UTC](https://community.bitquery.io/t/fetching-all-30k-market-cap-crossed-tokens-on-solana/2247/1 "2025-01-27T04:26:42Z")

</div>

Hello, everyone.  
I need your urgent help.  
Is it possible to fetch all tokens market cap crossed over 30k?  
I tested using :  
“query MyQuery {  
Solana {  
TokenSupplyUpdates(  
where: {TokenSupplyUpdate: {PostBalanceInUSD: {ge: “300000”}}}  
orderBy: {descending: Block\_Time}  
limitBy: {by: TokenSupplyUpdate\_Currency\_MintAddress, count: 1}  
) {  
TokenSupplyUpdate {  
Marketcap: PostBalanceInUSD  
Currency {  
Name  
Symbol  
MintAddress  
Decimals  
Uri  
}  
}  
}  
}  
}”  
But I can’t get all tokens.

---

<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:** [January 29, 2025, 12:44pm UTC](https://community.bitquery.io/t/fetching-all-30k-market-cap-crossed-tokens-on-solana/2247/2 "2025-01-29T12:44:38Z")

</div>

```auto
query MyQuery {
  Solana {
    TokenSupplyUpdates(
      where: {TokenSupplyUpdate: {PostBalanceInUSD: {ge: "30000"}}}
      orderBy: {descending: TokenSupplyUpdate_PostBalanceInUSD}
      limitBy: {by: TokenSupplyUpdate_Currency_MintAddress, count: 1}
    ) {
      TokenSupplyUpdate {
        Marketcap: PostBalanceInUSD
        Currency {
          Name
          Symbol
          MintAddress
          Decimals
          Uri
        }
      }
    }
  }
}

```

EAP is only realtime data + 8h of past data so all tokens will not be covered