е2

Returns 100 DEX trades by token on Solana, where currency symbol is GYAT and block time since 2025-01-01, sorted by USD, highest first: currency name, currency symbol, program address, side currency name, side program address, side currency symbol, side type and 6 more fields.

By Romario · saved 2 February 2025 · Bitquery API v2

What it returns

Filters

The query

query pairs($time_ago: DateTime) {
  Solana(network: solana, dataset: realtime) {
    DEXTradeByTokens(
      where: {Block: {Time: {since: $time_ago}}, Transaction: {Result: {Success: true}}, Trade: {Side: {Currency: {}}, Currency: {Symbol: {is: "GYAT"}}}}
      orderBy: {descendingByField: "usd"}
      limit: {count: 100}
    ) {
      Trade {
        Currency {
          Name
          Symbol
          ProgramAddress
        }
        Side {
          Currency {
            Name
            ProgramAddress
            Symbol
          }
          Type
        }
        Dex {
          ProtocolName
        }
        price_usd: PriceInUSD(maximum: Block_Time)
      }
      amount: sum(of: Trade_Side_Amount)
      usd: sum(of: Trade_Side_AmountInUSD)
      makers: uniq(of: Trade_Account_Address)
      count(selectWhere: {ge: "0"})
    }
  }
}

Variables

{"time_ago": "2025-01-01T00:00:00Z"}

Similar queries