liquidity removals

Returns 10 DEX pools on Solana, where quote currency mint address is So1111…1112 or 111111…1111, block time since 2024-10-23 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 · Bitquery API v2

What it returns

Filters

The query

query ($time_5min_ago: DateTime) {
  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}}, Block: {Time: {since: $time_5min_ago}}}
    ) {
      Pool {
        Market {
          MarketAddress
          BaseCurrency {
            MintAddress
            Symbol
            Name
          }
          QuoteCurrency {
            MintAddress
            Symbol
            Name
          }
        }
        Dex {
          ProtocolFamily
          ProtocolName
        }
        Quote {
          PostAmount
          PriceInUSD
          PostAmountInUSD
        }
        Base {
          removedLiquidity: ChangeAmount
          PostAmount
        }
      }
    }
  }
}

Variables

{
  "time_5min_ago":"2024-10-23T12:43:00Z"
}

Similar queries