sum of raydium trades gt 100000

Returns 10 DEX trades by token on Solana, where DEX protocol family is Raydium and side amount is above 0, sorted by volume USD, highest first: account owner, currency symbol, currency mint address, sum of trade amount and sum of trade side amount in USD.

By Divyasshree · saved 4 November 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query DexMarkets {
  Solana {
    DEXTradeByTokens(
      orderBy: {descendingByField: "volumeUSD"}
      limit: {count: 10}
      where: {Trade: {Dex: {ProtocolFamily: {is: "Raydium"}}, Side: {Amount: {gt: "0"}}}, Transaction: {Result: {Success: true}}}
    ) {
      Trade {
        Account {
          Owner
        }
        Currency {
          Symbol
          MintAddress
        }
      }
      bought: sum(
        of: Trade_Amount
        if: {Trade: {Side: {Type: {is: buy}}}}
        selectWhere: {ge: "1000000"}
      )
      volumeUSD: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Similar queries