Tokens with traders

Returns 100 DEX trades by token on Solana, where block time after 2024-09-02, sorted by USD, highest first: currency symbol, currency name, currency mint address, fungible, trade amount, amount in USD, unique of trade side currency mint address and 5 more fields.

By Aleksey · saved 2 September 2024 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query ($time_ago: DateTime!) {
  Solana(aggregates: only) {
    DEXTradeByTokens(
      where: {Block: {Time: {after: $time_ago}}, Transaction: {Result: {Success: true}}}
      orderBy: {descendingByField: "usd"}
      limit: {count: 100}
    ) {
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
          Fungible
        }
        Amount(maximum: Block_Slot)
        AmountInUSD(maximum: Block_Slot)
      }
      pairs: uniq(of: Trade_Side_Currency_MintAddress)
      dexes: uniq(of: Trade_Dex_ProgramAddress)
      amount: sum(of: Trade_Amount)
      usd: sum(of: Trade_AmountInUSD)
      traders: uniq(of: Trade_Account_Owner)
      count
    }
  }
}

Variables

{
  "time_ago": "2024-09-02T07:42:46Z"
}

Similar queries