top100sol

Returns 100 DEX trades by token on Solana, where DEX protocol family is not pump and block time after 2025-02-01, sorted by USD, highest first: currency symbol, currency name, currency mint address, side currency symbol, side currency name, side currency mint address, price in USD and 5 more fields.

By Robert McEwen · saved 2 February 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($time_ago: DateTime, $wsol: String!, $usdc: String!, $usdt: String!) {
  Solana {
    DEXTradeByTokens(
      where: {Transaction: {Result: {Success: true}}, Block: {Time: {after: $time_ago}}, Trade: {Dex: {ProtocolFamily: {not: "pump"}}}, any: [{Trade: {Currency: {MintAddress: {notIn: [$usdc, $usdt]}}, Side: {Currency: {MintAddress: {is: $wsol}}}}}, {Trade: {Currency: {MintAddress: {not: $usdc}}, Side: {Currency: {MintAddress: {is: $usdt}}}}}, {Trade: {Side: {Currency: {MintAddress: {is: $usdc}}}}}, {Trade: {Currency: {MintAddress: {notIn: [$wsol, $usdc, $usdt]}}, Side: {Currency: {MintAddress: {notIn: [$wsol, $usdc, $usdt]}}}}}]}
      orderBy: {descendingByField: "usd"}
      limit: {count: 100}
    ) {
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
        }
        Side {
          Currency {
            Symbol
            Name
            MintAddress
          }
        }
        price_last: PriceInUSD(maximum: Block_Slot)
        price_1h_ago: PriceInUSD(minimum: Block_Slot)
      }
      dexes: uniq(of: Trade_Dex_ProgramAddress)
      amount: sum(of: Trade_Side_Amount)
      usd: sum(of: Trade_Side_AmountInUSD)
      traders: uniq(of: Trade_Account_Owner)
      count(selectWhere: {ge: "100"})
    }
  }
}

Variables

{
  "time_ago": "2025-02-01T16:03:59Z",
  "wsol": "So11111111111111111111111111111111111111112",
  "usdc": "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v",
  "usdt": "Es9vMFrzaCERmJfrF4H2FYD4KCoNkY11McCe8BenwNYB"
}

Similar queries