M7-DexSniper

Returns 100 DEX trades by token and DEX pools on Solana, where DEX protocol name is pump and block time since 2025-02-07, sorted by pool base post amount maximum: market address, currency symbol, currency name, currency mint address, URI, trade price, count and 4 more fields.

By M7-DexSniper · saved 7 February 2025 · run 6 times · Bitquery API v2

What it returns

Filters

The query

query ($from: DateTime) {
  Solana {
    DEXTradeByTokens(
      limit: {count: 200}
      orderBy: {descendingByField: "Trade_lastPrice_maximum"}
      where: {Block: {Time: {since: $from}}, Trade: {Currency: {Native: false}, Dex: {ProtocolName: {is: "pump"}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Market {
          MarketAddress
        }
        Currency {
          Symbol
          Name
          MintAddress
          Uri
        }
        lastPrice: Price(maximum: Block_Slot)
        prePrice: Price(minimum: Block_Slot)
      }
      count
      traders: uniq(of: Trade_Account_Owner)
      buy_usd: sum(of: Trade_Side_AmountInUSD, if: {Trade: {Side: {Type: {is: buy}}}})
      sell_usd: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}}
      )
    }
    DEXPools(
      orderBy: {ascendingByField: "Pool_Base_PostAmount_maximum"}
      limit: {count: 100}
      where: {Pool: {Dex: {ProtocolName: {is: "pump"}}}}
    ) {
      Pool {
        Market {
          BaseCurrency {
            MintAddress
          }
          MarketAddress
        }
        Base {
          PostAmount(maximum: Block_Slot, selectWhere: {gt: "206900000"})
        }
      }
    }
  }
}

Variables

{
  "from": "2025-02-07T14:40:42Z"
}

Similar queries