# Why are there so few results from query to get all pump tokens?

**URL:** <https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381>\
**Category:** GraphQL API\
**Created:** [May 16, 2025, 3:01pm UTC](https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381 "2025-05-16T15:01:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![crediblecoinsforall](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@crediblecoinsforall](https://community.bitquery.io/u/crediblecoinsforall)\
**Post date:** [May 16, 2025, 3:01pm UTC](https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381/1 "2025-05-16T15:01:40Z")

</div>

Here is my query copied from pumpfun docs to return all pump tokens with market cap \> 1m. It currently returns only 29 records. There should be many more. How come there is so few?

```auto
{
  Solana {
    DEXTrades(
      limitBy: {by: Trade_Buy_Currency_MintAddress, count: 1}
      limit: {count: 200, offset: 0}
      orderBy: {descending: Trade_Buy_Price}
      where: {Trade: {Dex: {ProtocolName: {is: "pump_amm"}}, Buy: {Currency: {UpdateAuthority: {is: "TSLvdd1pWpHVjahSpsvCXUbgwsL3JAcvokwaKt1eokM"}}, PriceInUSD: {gt: 0.0001}}, Sell: {AmountInUSD: {gt: "10"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2025-01-01T13:31:12.411241Z"}}}
    ) {
      Trade {
        Buy {
          Price(maximum: Block_Time)
          PriceInUSD(maximum: Block_Time)
          Currency {
            Name
            Symbol
            MintAddress
            Decimals
            Fungible
            Uri
          }
        }
        Market {
          MarketAddress
        }
      }
      joinTokenSupplyUpdates(
        TokenSupplyUpdate_Currency_MintAddress: Trade_Buy_Currency_MintAddress
        join: inner
        where: {Instruction: {Program: {Address: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}, Method: {is: "create"}}}}
      ) {
        Block {
          Time
        }
        Transaction {
          Dev: Signer
          Signature
        }
      }
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![akshat.bitquery](https://avatars.discourse-cdn.com/v4/letter/a/dbc845/32.png) [@akshat.bitquery](https://community.bitquery.io/u/akshat.bitquery)\
**Post date:** [May 19, 2025, 8:30am UTC](https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381/2 "2025-05-19T08:30:43Z")

</div>

Hey,  
Right now the query is using joins too, which checks for if the token was created in last 8 hours only then only the token will be present in a response. Check this updated query with removed join, this will give you many results,

```auto
{
  Solana {
    DEXTrades(
      limitBy: {by: Trade_Buy_Currency_MintAddress, count: 1}
      limit: {count: 200, offset: 0}
      orderBy: {descending: Trade_Buy_Price}
      where: {Trade: {Dex: {ProtocolName: {is: "pump_amm"}}, Buy: {Currency: {UpdateAuthority: {is: "TSLvdd1pWpHVjahSpsvCXUbgwsL3JAcvokwaKt1eokM"}}, PriceInUSD: {gt: 0.0001}}, Sell: {AmountInUSD: {gt: "10"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2025-01-01T13:31:12.411241Z"}}}
    ) {
      Trade {
        Buy {
          Price(maximum: Block_Time)
          PriceInUSD(maximum: Block_Time)
          Currency {
            Name
            Symbol
            MintAddress
            Decimals
            Fungible
            Uri
          }
        }
        Market {
          MarketAddress
        }
      }
    }
  }
}

```

---

<div class="post-metadata">

**Author:** ![crediblecoinsforall](https://avatars.discourse-cdn.com/v4/letter/c/87869e/32.png) [@crediblecoinsforall](https://community.bitquery.io/u/crediblecoinsforall)\
**Post date:** [May 26, 2025, 7:57pm UTC](https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381/3 "2025-05-26T19:57:52Z")

</div>

thank you. is there anyway to get the creation time of the token without using the join? i’d also like to get creation time.

---

<div class="post-metadata">

**Author:** ![akshat.bitquery](https://avatars.discourse-cdn.com/v4/letter/a/dbc845/32.png) [@akshat.bitquery](https://community.bitquery.io/u/akshat.bitquery)\
**Post date:** [May 29, 2025, 5:08pm UTC](https://community.bitquery.io/t/why-are-there-so-few-results-from-query-to-get-all-pump-tokens/2381/4 "2025-05-29T17:08:32Z")

</div>

Here try this API, but we only have last hours of data of Solana, so this will give a response only if the token was created in last 8 hours. [Pump Fun API | Blockchain Data API (V2)](https://docs.bitquery.io/docs/examples/Solana/Pump-Fun-API/#get-the-creation-time--creator-of-a-pump-fun-token)