Top traders (WETH)

Returns 100 DEX trades by token on Ethereum, where currency smart contract is 0xc02a…6cc2 and block time since 2024-11-03, sorted by volume USD, highest first: buyer, seller, protocol family, sum of trade amount and sum of trade side amount in USD.

By Den · saved 6 November 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query topTraders($network: evm_network, $time_ago: DateTime, $token: String) {
  EVM(network: $network) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "volumeUsd"}
      limit: {count: 100}
      where: {Trade: {Currency: {SmartContract: {is: $token}}}, Block: {Time: {since: $time_ago}}}
    ) {
      Trade {
        Buyer
        Seller
        Dex {
          ProtocolFamily
        }
      }
      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)
    }
  }
}

Variables

{
  "network": "eth",
  "token": "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2",
  "time_ago": "2024-11-03T11:05:35Z"
}

Similar queries