List traded pumpfun tokens

Returns 100 DEX trades by token on Solana, where DEX protocol name is pump, sorted by trade last price USD maximum, highest first: block time, market address, currency symbol, currency name, currency mint address, trade price and price in USD.

By Aleksey · saved 11 July 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($after: DateTime) {
              Solana {
                DEXTradeByTokens(
                  limit: {count: 100}
                  orderBy: {descendingByField: "Trade_lastPriceUsd_maximum"}
                  where: {Trade: {Side: {Currency: {Native: true}}, Dex: {ProtocolName: {is: "pump"}}}, Transaction: {Result: {Success: true}}}
                ) {
                  Block {
                    Time(maximum: Block_Slot, selectWhere: {after: $after})
                  }
                  Trade {
                  Market{MarketAddress}
                    Currency {
                      Symbol
                      Name
                      MintAddress
                    }
                    maxPrice: Price(maximum: Block_Slot, selectWhere: {le: 3.8e-7})
                    lastPriceUsd: PriceInUSD(maximum: Block_Slot)
                    lastPrice: Price(maximum: Block_Slot)
                    prePrice: Price(maximum: Block_Slot, if: {Block: {Time: {before: $after}}})
                  }
                }
              }
            }

Variables

{
  "after": "2024-07-11T12:00:00Z"
}

Similar queries