Copy of Top traders with their bought, sold and total volume

Returns DEX trades by token on Solana, where currency mint address is CowdtF…pump, block time since 2024-07-19 and block time till 2024-07-19: protocol name, protocol family, program address, currency symbol, currency name, currency mint address, account address and 2 more fields.

By George · saved 19 July 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query TopTraders {
  Solana {
    DEXTradeByTokens(
      where: {Trade: {Currency: {MintAddress: {is: "CowdtFAhTn9CMFtRnYJj5h9ep1Y1EMQj7j7RhH54pump"}}}, Transaction: {Result: {Success: true}}, Block: {Time: {since: "2024-07-19T11:03:43.000Z", till: "2024-07-19T11:33:43.999Z"}}}
    ) {
      Trade {
        Dex {
          ProtocolName
          ProtocolFamily
          ProgramAddress
        }
        Currency {
          Symbol
          Name
          MintAddress
        }
        Account {
          Address
        }
      }
      bought: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: buy}}}})
      sold: sum(of: Trade_Amount, if: {Trade: {Side: {Type: {is: sell}}}})
      volume: sum(of: Trade_Amount)
      volumeUsd: sum(of: Trade_Side_AmountInUSD)
    }
  }
}

Similar queries