top_volume_sol_coins

Returns DEX trades by token on Solana, where currency mint address is not EPjFWd…Dt1v, side currency mint address is So1111…1112 and block time before 2024-12-25, 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 SBJ · saved 25 December 2024 · Bitquery API v2

What it returns

Filters

The query

query ($beforeBlockTime: DateTime!, $afterBlockTime: DateTime!) {
  Solana {
    DEXTradeByTokens(
      orderBy: {descendingByField: "usd"}
      where: {Transaction: {Result: {Success: true}}, Block: {Time: {before: $beforeBlockTime, after: $afterBlockTime}}, Trade: {Currency: {MintAddress: {not: "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"}, Symbol: {not: ""}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}}
    ) {
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
        }
        Side {
          Currency {
            Symbol
            Name
            MintAddress
          }
        }
        price_last: PriceInUSD(maximum: 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

{
  "beforeBlockTime": "2024-12-25T08:38:18Z",
  "afterBlockTime": "2024-11-25T08:34:00Z"
}

Similar queries