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

GraphQL API
1

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?

{
  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
        }
      }
    }
  }
}
2

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,

{
  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
        }
      }
    }
  }
}
3

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.

4

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)

1 Like