Pumpfun coins with price / mc with limit and delta

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, currency symbol, currency name, currency mint address, trade price, price in USD, sum of trade side amount and 2 more fields.

By Aleksey · saved 21 June 2024 · run 17 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  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: "2024-06-21T11:20:00Z"})
      }
      Trade {
        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: "2024-06-21T11:20:00Z"}}})
      }
      
    
      sol_buy: sum(of: Trade_Side_Amount if: {Trade: {Side: {Type: {is: buy}}}})
      sol_sold: sum(of: Trade_Side_Amount if: {Trade: {Side: {Type: {is: sell}}}})
      total_usd: sum(of: Trade_Side_AmountInUSD)
      trades: count
    }
  }
}

Similar queries