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

Returns 10 DEX pools on Solana, where quote currency mint address is EPjFWd…Dt1v, base currency mint address is So1111…1112 and base change amount is above 0, sorted by liquidity added, highest first: signer and sum of pool base change amount in USD.

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

What it returns

Filters

The query

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

Similar queries