top-ten-liquidity-providers-for-a-pair

Returns 10 DEX pools on Solana, where base currency mint address is 5FGULy…pump, quote currency mint address is 111111…1111 and base currency change amount is above 0, sorted by liquidity added, highest first: signer and sum of pool base change amount.

By Kshitij Mahajan · saved 28 August 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  Solana {
    DexPools(
      limit: {count: 10}
      where: {
        Pool: {
          Market: {
            BaseCurrency: {
              MintAddress: {
                is: "5FGULyTir641wnz7gr2p2kiYYpWboVYE83qos1r9pump"
              }
            },
            QuoteCurrency: {
              MintAddress: {
                is: "11111111111111111111111111111111"
              }
            }
          },
          BaseCurrency: {ChangeAmount: {gt: "0"}}
        },
        Transaction: {
          Result: {
            Success: true
          }
        }
      }
      orderBy: {descendingByField: "liquidityAdded"}
    ) {
      Transaction {
        Signer
      }
      liquidityAdded: sum(of: Pool_Base_ChangeAmount)
    }
  }
}

Similar queries