Shyft
Start BuildingSupportWebsite
  • Welcome
    • 👋Introducing Shyft
    • 🏗️Start Building
  • Solana Infrastructure
    • 🚁Shyft RPCs
  • Yellowstone gRPC Network
    • Decoding gRPC Latency
    • ⚡gRPC Docs
      • Introduction
      • Authentication
      • Subscribe Requests
      • FAQ
      • Getting Started
        • Initializing the Yellowstone Client
        • Making a gRPC connection
        • Adding a Reconnection Mechanism
        • 🔥Replaying Slots with Solana yellowstone gRPCs
        • Modifying your Subscribe Request
        • Closing a gRPC Connection
      • Subscribing to Transactions
        • All Transactions of an address
        • Subscribing to all transactions of a Liquidity Pool
        • Subscribing to all transactions of multiple addresses
        • Subscribing to all transactions of a Token
      • Subscribing to Accounts
        • Account Updates for a Program
        • Account Updates for an Address
        • Account updates using memcmp
      • Streaming Blocks & BlocksMeta
        • Streaming Block Updates
        • Subscribing to BlocksMeta
      • Modifying & Unsubscribing
  • Solana defi data
    • DeFI APIs
      • Get Pool By Address
      • Get Pools By Token Pair
      • Get All Pools for a Token
      • Get Liquidity Details of a Pool
  • Callbacks
    • ☎️What are Callbacks?
      • Transaction Callbacks
      • Account Callbacks
    • 📔Callback APIs
      • Response Structure
      • List Callbacks
      • Register callback
      • Remove callback
      • 🔥Pause a callback
      • 🔥Resume a callback
      • Update Callbacks
      • Add Addresses
      • Remove addresses
  • Solana Super Indexers
    • 🌩️GraphQL APIs
      • Getting Started
      • Building Queries
      • Paginating Response
      • Applying Filters
      • Ordering and Sorting Data
    • 📀Case Studies
      • Tensor
        • Get Active Listings of a Wallet
        • Get Active Bids of a Wallet
        • Get Active Listings of a Collection
        • Get all Bids of a Collection
        • Get all Pools of a Margin Account
        • Get all Pools by Owner
      • Raydium
        • Get Pool By Address
        • Get Pools By Token Address
        • Get Pools Created Between Time
        • Get Pool Burn Percentage
        • Get Liquidity Details of a Pool
        • Get Pool and OpenBook Market Info
        • Get Token Supply Percentage In Pool
      • Orca Whirlpool
        • Get Pool by Address
        • Get Pool by Token Address
        • Get Positions for a Pool
        • Get Positions for a Wallet
        • Get Liquidity Details of a Pool
      • Kamino
        • Get Borrow Details of a Wallet
        • Get Deposit Details of a Wallet
        • Get Reserve Details
      • Cross Marketplace Queries
        • Get active listings across marketplaces for a wallet
        • Get listings for a collection across marketplaces
        • Get floor price of a collection
      • Cross Defi Queries
        • Fetch Liquidity Pools for Token
      • Native Staking
        • Get Stakes for a Wallet
        • Get Stakes For Validator
      • Governance/Realms
        • Get DAO Token Owners
        • Get Proposals For Governing Mint
        • Get All Proposals For DAO
        • Get DAO Treasury Info
        • Get All Active Proposals For Wallet
      • Meteora
        • Get All LB Position Pairs
        • Get Position of a User Wallet
        • Get Pool by Token Addresses
        • Get All Deposits for a User
        • Get All Withdraws for a User
        • Get All Fees Claimed by a User
        • Get All User Positions and Deposits for a Pool
        • Get All User Positions and Withdrawals for a Pool
      • Fluxbeam
        • Get Pool by Address
        • Get Pool by Token Addresses
      • Drift
        • Get User account for Delegate
        • Get User accounts based on authority
        • Get User details based on Referrer
        • Get Borrow/Deposit Amount for an User
        • Get PrepPositions for an User Account
        • Getting OrderId and userOrderId
        • Get OpenOrders for a User Account
      • 🔥Pumpswap
        • 🔥Get Pool by Address
        • 🔥Get Pool by Creator Address
        • 🔥Get Pools by Token Addresses
      • Raydium Launchpad
        • Get Bonding Curve Details by Pool Address
        • Get All Pools for a Creator
        • Get Pools by Token Addresses
        • Get Migration details of a Pool
  • Solana APIs
    • API Reference
    • Transactions
      • Parsed Transaction Structure
      • Transaction APIs
        • History
        • Parse Signature
        • Parse Multiple Signatures
        • Send
        • Send Multiple
    • NFT
      • 🔥Create Gasless
      • Create
      • Read All
      • Burn
      • 🔥Burn Multiple NFTs V2
      • Update
      • 🔥Create NFT from Metadata
      • 🔥Read Wallet Nfts
      • 🔥Read Selected NFTs
      • 🔥Get NFT Owners
      • 🔥Update NFT Metadata Uri
      • 🔥Update V2
      • Search
      • Transfer
      • Transfer Multiple NFTs
      • Mint
      • Read
    • Wallet
      • Get Balance
      • Get Token Balance
      • Get All Tokens Balance
      • Get Portfolio
      • Resolve Address
      • Get All Domains
      • Get Stake Accounts
    • Fungible Tokens
      • Create
      • Mint
      • Burn
      • 🔥Update
      • Get Token Info
      • Transfer
      • Airdrop
  • 📘Dev Guides
    • 📀gRPC Case Studies
      • Pumpfun
        • Streaming and Parsing Pump.fun Transactions
        • Streaming and Parsing Pump.fun Accounts
        • Detecting new Token launches on Pump.fun
        • Detecting Buy/Sell Transactions on Pump.fun
        • Detecting tokens migrating from Pump.fun to Pump Swap AMM
      • PumpSwap AMM
        • Streaming and Parsing Pump Swap Transactions
        • Streaming and Parsing Pump Swap AMM Accounts
        • Detecting Buy/Sell Transactions on Pump Swap AMM
        • Detecting tokens migrating from Pump.fun to Pump Swap AMM
Powered by GitBook
On this page

Was this helpful?

  1. Solana Super Indexers
  2. Case Studies
  3. Meteora

Get All User Positions and Deposits for a Pool

Fetch all user positions for a pool for Meteora DLMM and their deposit amounts

In certain cases, dApps may need to fetch all the users, their positions and their deposits for a pool. One such case can be dashboard like UI for one particular pool, where every information related to the pool is displayed in details. We can use SHYFT's GraphQL APIs to fetch the above mentioned case. The steps are as follows:

  • For a pool address, we fetch all the pool specific details, such as the tokens involved, its activeId, or lastUpdatedAt value. This can be obtained by querying the meteora_dlmm_LbPair account, with pubkey field being _eq to the pool address.

  • We fetch all the position details and the users for that particular pool, by querying the meteora_dlmm_Position and meteora_dlmm_PositionV2 accounts, by filtering the LbPair field being equal to the pool address.

  • Once we have the position addresses from the previous step, we get all transactions for the position address of each position. With SHYFT's parsed transactions, we can directly get the amounts deposited to the pool, for that particular position.

import { ShyftSdk, Network } from "@shyft-to/js";

const SHYFT_API_KEY = "YOUR_SHYFT_API_KEY";

const shyft = new ShyftSdk({ apiKey: SHYFT_API_KEY, network: Network.Mainnet });

async function getPoolDetails(poolAddress) {
  //querying pool details with LbPair address
  const operationsDoc = `
      query MyQuery {
        meteora_dlmm_LbPair(
          where: {pubkey: {_eq: ${JSON.stringify(poolAddress)}}}
        ) {
          activeId
          tokenXMint
          tokenYMint
          pubkey
          lastUpdatedAt
        }
      }
    `; //you can cherrypick the fields as per your requirement

  const result = await fetch(
    `https://programs.shyft.to/v0/graphql/accounts?api_key=${SHYFT_API_KEY}&network=mainnet-beta`, //SHYFT's GQL endpoint
    {
      method: "POST",
      body: JSON.stringify({
        query: operationsDoc,
        variables: {},
        operationName: "MyQuery",
      }),
    },
  );

  const { errors, data } = await result.json();
  if (errors) {
    return {
      meteora_dlmm_LbPair: [],
    };
  }

  return data;
}
async function getPositionsByPool(poolAddress) {
  //querying pool details with LbPair address
  const operationsDoc = `
      query MyQuery {
         meteora_dlmm_Position(
          where: {lbPair: {_eq: ${JSON.stringify(poolAddress)}}}
        ) {
          _lamports
          lbPair
          owner
          pubkey
        }
        meteora_dlmm_PositionV2(
          where: {lbPair: {_eq: ${JSON.stringify(poolAddress)}}}
        ) {
          _lamports
          lbPair
          owner
          pubkey
        }
      }
    `; //you can cherrypick the fields as per your requirement

  const result = await fetch(
    `https://programs.shyft.to/v0/graphql/accounts?api_key=${SHYFT_API_KEY}&network=mainnet-beta`, //SHYFT's GQL endpoint
    {
      method: "POST",
      body: JSON.stringify({
        query: operationsDoc,
        variables: {},
        operationName: "MyQuery",
      }),
    },
  );

  const { errors, data } = await result.json();
  if (errors) {
    return {
      positionsV1: [],
      positionV2: [],
    };
  }
  let positionsV1 = [];
  let positionsV2 = [];

  if (data.meteora_dlmm_Position.length > 0) {
    positionsV1 = data.meteora_dlmm_Position;
  }
  if (data.meteora_dlmm_PositionV2.length > 0) {
    positionsV2 = data.meteora_dlmm_PositionV2;
  }

  return {
    positionsV1: positionsV1,
    positionsV2: positionsV2,
  };
}

async function getUserDepositsByPositionV1(positionAddress, tokenX, tokenY) {
  let addLiquidityFound = false;
  let genesisTxnReached = false;
  let addLiquidity = [];
  let lastSignature = undefined;

  while (!addLiquidityFound || !genesisTxnReached) {
    const transactions = await shyft.transaction.history({
      account: positionAddress,
      network: Network.Mainnet,
      txNum: 10,
      beforeTxSignature: lastSignature,
    });
    transactions.map((txn) => {
      if (txn.type === "ADD_LIQUIDITY") addLiquidity.push(txn);
      addLiquidityFound = true;
    });

    if (transactions.length < 10) {
      genesisTxnReached = true;
      break;
    }
    lastSignature = transactions[transactions.length - 1].signatures[0];
  }
  const amountAddedDetails = [];
  addLiquidity.map((addLiquidityTxn) => {
    addLiquidityTxn.actions.map((action) => {
      let eachAddedTxn = {
        txn_id: addLiquidityTxn.signatures[0],
        onchain_timestamp: addLiquidityTxn.timestamp,
      };
      if (action.type === "ADD_LIQUIDITY") {
        action.info.liquidity_added.map((liquidityDetails) => {
          if (liquidityDetails.token_address === tokenX) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenX_amount: liquidityDetails.amount_raw,
              tokenX_address: liquidityDetails.token_address,
            };
          }
          if (liquidityDetails.token_address === tokenY) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenY_amount: liquidityDetails.amount_raw,
              tokenY_address: liquidityDetails.token_address,
            };
          }
        });
        if (eachAddedTxn.tokenX_amount && eachAddedTxn.tokenY_amount)
          amountAddedDetails.push(eachAddedTxn);
      }
    });
  });

  return amountAddedDetails;
}

async function getUserDepositsByPositionV2(
  ownerAddress,
  positionAddress,
  lbPair,
  tokenX,
  tokenY,
) {
  let genesisTxnReached = false;
  let tokenTransferTxns = [];
  let oneSideTokenTransferTxns = [];
  let lastSignature = undefined;

  while (!genesisTxnReached) {
    const transactions = await shyft.transaction.history({
      account: positionAddress,
      network: Network.Mainnet,
      txNum: 10,
      beforeTxSignature: lastSignature,
    });
    
    transactions.map((txn) => {
      if (txn.type === "TOKEN_TRANSFER") {
        txn.actions.map((action) => {
          if (
            action.type === "TOKEN_TRANSFER" &&
            action.info.sender === ownerAddress &&
            action.info.receiver === lbPair
          ) {
            tokenTransferTxns.push(txn);
          }
        });
      }
      if(txn.type === "ADDLIQUIDITYBYSTRATEGYONESIDE") {
        oneSideTokenTransferTxns.push(txn)
      };
      if (txn.type === "INITIALIZEPOSITION") tokenTransferTxns.push(txn);
      // addLiquidity = txn;
    });

    if (transactions.length < 10) {
      genesisTxnReached = true;
      break;
    }
    lastSignature = transactions[transactions.length - 1].signatures[0];
  }
  
  const addedLiquidityDetails = [];

  if (tokenTransferTxns.length > 0) {
    tokenTransferTxns.forEach((tokenTransferTxn) => {
      let eachAddedTxn = {
        txn_id: tokenTransferTxn.signatures[0],
        onchain_timestamp: tokenTransferTxn.timestamp,
      };
      
      tokenTransferTxn.actions.map((action) => {
        if (action.type === "TOKEN_TRANSFER") {
          
          if (action.info.token_address === tokenX) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenX_amount: action.info.amount_raw,
              tokenX_address: action.info.token_address,
            };
          }
          if (action.info.token_address === tokenY) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenY_amount: action.info.amount_raw,
              tokenY_address: action.info.token_address,
            };
          }
        }
      });
      if (eachAddedTxn.tokenX_amount && eachAddedTxn.tokenY_amount)
        addedLiquidityDetails.push(eachAddedTxn);
    });

  }

  if (oneSideTokenTransferTxns.length > 0) {
    oneSideTokenTransferTxns.forEach((oneSideTokenTransferTxn) => {
      let eachAddedTxn = {
        txn_id: oneSideTokenTransferTxn.signatures[0],
        onchain_timestamp: oneSideTokenTransferTxn.timestamp,
      };
      
      oneSideTokenTransferTxn.actions.map((action) => {
        if (action.type === "TOKEN_TRANSFER") {
          
          if (action.info.token_address === tokenX) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenX_amount: action.info.amount_raw,
              tokenX_address: action.info.token_address,
              tokenY_amount: 0,
              tokenY_address: null,
            };
          }
          if (action.info.token_address === tokenY) {
            eachAddedTxn = {
              ...eachAddedTxn,
              tokenY_amount: action.info.amount_raw,
              tokenY_address: action.info.token_address,
              tokenX_amount: 0,
              tokenX_address: null,
            };
          }
        }
      });
      addedLiquidityDetails.push(eachAddedTxn);
    });

  }
  
  return addedLiquidityDetails;
}

async function getUserPoolDetails(poolAddress) {
    let allPoolPositionDetails = [];
    let allPoolPositionDetailsV1 = [];
  const poolDetails = await getPoolDetails(poolAddress);
  const tokenMintX = poolDetails.meteora_dlmm_LbPair[0].tokenXMint;
  const tokenMintY = poolDetails.meteora_dlmm_LbPair[0].tokenYMint;
  const positions = await getPositionsByPool(poolAddress);

  for (let i = 0; i < positions.positionsV1.length; i++) {
    const currentPositionV1 = positions.positionsV1[i];
    const liquidityDetails = await getUserDepositsByPositionV1(
      currentPositionV1.pubkey,
      tokenMintX,
      tokenMintY,
    );

    allPoolPositionDetailsV1.push({
      owner: currentPositionV1.owner,
      positionAddress: currentPositionV1.pubkey,
      poolAddress: poolAddress,
      liquidityAddedDetails: liquidityDetails,
    });
  }
  for (let i = 0; i < positions.positionsV2.length; i++) {
    const currentPositionV2 = positions.positionsV2[i];
    const liquidityDetails = await getUserDepositsByPositionV2(
      currentPositionV2.owner,
      currentPositionV2.pubkey,
      poolAddress,
      tokenMintX,
      tokenMintY,
    );

    allPoolPositionDetails.push({
      owner: currentPositionV2.owner,
      positionAddress: currentPositionV2.pubkey,
      poolAddress: poolAddress,
      liquidityAddedDetails: liquidityDetails,
    });
  }
  console.dir({
    poolAddress: poolAddress,
    tokenXMint: tokenMintX,
    tokenYMint: tokenMintY,
    allPoolPositionV1Details: allPoolPositionDetailsV1,
    allPoolPositionV2Details: allPoolPositionDetails
  },{depth:null})
}
getUserPoolDetails("FFpF3BNiBvtewyACdxvvedLDdbZ3einkkpJ7NnknpeqU");
//enter your pool address
{
  poolAddress: "FFpF3BNiBvtewyACdxvvedLDdbZ3einkkpJ7NnknpeqU",
  tokenXMint: "HUBsveNpjo5pWqNkH57QzxjQASdTVXcSK7bVKTSZtcSX",
  tokenYMint: "So11111111111111111111111111111111111111112",
  allPoolPositionV1Details: [],
  allPoolPositionV2Details: [
    {
      owner: "9dutnta2c6BqhqyX6pwBFpjgi1cHwNtRKWhSf9rjxko1",
      positionAddress: "7bDyuB2Zdv7nYxC7ZyCoXxzkYUauVkw3qwx7mqUKDzJq",
      poolAddress: "FFpF3BNiBvtewyACdxvvedLDdbZ3einkkpJ7NnknpeqU",
      liquidityAddedDetails: [
        {
          txn_id: "4QtM8ASQi9YrwAmBkUWegEbaia3kTNcmR2xwaHei3RTASchc5Ue1uzF2idGgnEiZbvixnjpSYib3EPrQCpVsefuz",
          onchain_timestamp: "2024-05-08T14:59:02.000Z",
          tokenX_amount: 195933414,
          tokenX_address: "HUBsveNpjo5pWqNkH57QzxjQASdTVXcSK7bVKTSZtcSX",
          tokenY_amount: 199999952,
          tokenY_address: "So11111111111111111111111111111111111111112"
        }
      ]
    },
    {
      owner: "JPQmr9p2RF3X5TuBXxn6AGcEfcsHp4ehcmzE5Ys7pZD",
      positionAddress: "3Xu4RruYZEZ51MpxX7a8Kyh2sHC6fxhyFF1H7hQYfb3a",
      poolAddress: "FFpF3BNiBvtewyACdxvvedLDdbZ3einkkpJ7NnknpeqU",
      liquidityAddedDetails: [
        {
          txn_id: "4jn5Ff4viR17QpidRaMTwX3nQGkoQEhJp3eKWfY8j4McS2bdXsqpPF1oKAoiCzM2MHcK58hQemXNW3k89ky9GB16",
          onchain_timestamp: "2024-05-16T11:09:23.000Z",
          tokenX_amount: 1003322714.9999999,
          tokenX_address: "HUBsveNpjo5pWqNkH57QzxjQASdTVXcSK7bVKTSZtcSX",
          tokenY_amount: 913504790,
          tokenY_address: "So11111111111111111111111111111111111111112"
        }
      ]
    }
 ]
}//shortend sample response
PreviousGet All Fees Claimed by a UserNextGet All User Positions and Withdrawals for a Pool

Last updated 1 month ago

Was this helpful?

📀