Copy of New Query

Returns the latest DEX pool on Solana, where base currency mint address is 8TeCgG…invK, DEX program address is 6EF8rr…wF6P and currency mint address is 8TeCgG…invK: market address, base currency mint address, base currency symbol, base currency name, quote currency mint address, quote currency symbol, quote currency name and 13 more fields.

By hansel · saved 20 November 2024 · run 11 times · Bitquery API v2

What it returns

Filters

The query

query GetLatestLiquidityForPool {
  Solana {
    DEXPools(
      where: {Pool: {Market: {BaseCurrency: {MintAddress: {is: "8TeCgG7eUTEkhuBHdTjnzGGd3ERTq5nYYWkxriGZinvK"}}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}}}
      orderBy: {descending: Block_Slot}
      limit: {count: 1}
    ) {
      Pool {
        Market {
          MarketAddress
          BaseCurrency {
            MintAddress
            Symbol
            Name
          }
          QuoteCurrency {
            MintAddress
            Symbol
            Name
          }
        }
        Dex {
          ProtocolFamily
          ProtocolName
        }
        Quote {
          PostAmount
          PriceInUSD
          PostAmountInUSD
        }
        Base {
          PostAmount
        }
      }
    }
    DEXTradeByTokens(
      limit: {count: 1}
      orderBy: {descending: Block_Time}
      where: {Trade: {Currency: {MintAddress: {is: "8TeCgG7eUTEkhuBHdTjnzGGd3ERTq5nYYWkxriGZinvK"}}, Dex: {ProgramAddress: {is: "6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P"}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Currency {
          Name
          MintAddress
          Symbol
        }
        Amount
        AmountInUSD
        Price
        PriceInUSD
      }
    }
  }
}

Similar queries