Top sellers and buyers

Returns 10 DEX trades by token on Polygon, where currency smart contract is 0x53e0…ad39 and block time since 2024-05-16, sorted by amt, highest first: sum of trade amount in USD, seller and buyer.

By Aleksey · saved 17 May 2024 · run 4 times · Bitquery API v2

What it returns

Filters

The query

query(
  $network: evm_network 
	$currency: String
  $from: DateTime
) {
  top_sellers: EVM(network: $network dataset: realtime) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "amt"}
      limit: {count: 10}
      where: {
        Block: {
          Time: {
            since: $from
          }
        }
        Trade: {
          Currency: {
            SmartContract: {
              is: $currency
            }
          }
        }
        
      }
    
    ) {
      
      amt: sum(of: Trade_AmountInUSD)
    	
      Trade {
        Seller
      }
      
    }
  }
  top_buyers: EVM(network: $network dataset: realtime) {
    DEXTradeByTokens(
      orderBy: {descendingByField: "amt"}
      limit: {count: 10}
      where: {
        Block: {
          Time: {
            since: $from
          }
        }
        Trade: {
          Currency: {
            SmartContract: {
              is: $currency
            }
          }
        }
        
      }
    
    ) {
      
      amt: sum(of: Trade_AmountInUSD)
    	
      Trade {
        Buyer
      }
      
    }
  }
}

Variables

{
  "network": "matic",
  "currency": "0x53e0bca35ec356bd5dddfebbd1fc0fd03fabad39",
  "from": "2024-05-16T15:00:00Z"
}

Similar queries