liquidity removals

Returns 10 DEX pools on Solana, where quote currency mint address is So1111…1112 or 111111…1111 and base change amount is below 0, sorted by block time: market address, base currency mint address, base currency symbol, base currency name, quote currency mint address, quote currency symbol, quote currency name and 7 more fields.

By Akshat · saved 23 October 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    DEXPools(
      limit: {count: 10}
      orderBy: {ascending:Block_Time ascendingByField: "Pool_Base_removedLiquidity"}
      where: {Pool: {Base: {ChangeAmount: {lt: "0"}}, Market: {QuoteCurrency: {MintAddress: {in: ["So11111111111111111111111111111111111111112","11111111111111111111111111111111"]}}}}, Transaction: {Result: {Success: true}}}
    ) {
      Pool {
        Market {
          MarketAddress
          BaseCurrency {
            MintAddress
            Symbol
            Name
          }
          QuoteCurrency {
            MintAddress
            Symbol
            Name
          }
        }
        Dex {
          ProtocolFamily
          ProtocolName
        }
        Quote {
          PostAmount
          PriceInUSD
          PostAmountInUSD
        }
        Base {
          removedLiquidity: ChangeAmount
          PostAmount
        }
      }
    }
  }
}

Similar queries