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

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

By Kshitij Mahajan · saved 3 September 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

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

Similar queries