chart

Returns the latest 20 DEX trades by token, where DEX owner address is 0x3312…FDfD and trade price is above 0: block time, sum of trade amount and price in USD.

By prisma · saved 2 February 2025 · Bitquery API v2

What it returns

Filters

The query

query ($network: evm_network, $baseCurrency: String, $quoteCurrency: String, $from: DateTime, $till: DateTime) {
  EVM(dataset: combined, network: $network) {
    DEXTradeByTokens(
      limit: {count: 20}
      orderBy: {descendingByField: "Block_Time"}
      where: {Trade: {Currency: {SmartContract: {is: $baseCurrency}}, Side: {Currency: {SmartContract: {is: $quoteCurrency}}}, Price: {gt: 0}, Dex: {OwnerAddress: {is: "0x33128a8fC17869897dcE68Ed026d694621f6FDfD"}}}, Block: {Time: {since: $from, till: $till}}}
    ) {
      Block {
        Time(interval: {in: minutes, count: 10})
      }
      volume: sum(of: Trade_Amount)
      Trade {
        close: PriceInUSD(maximum: Block_Number)
      }
    }
  }
}

Variables

{
  "network": "base",
  "baseCurrency": "0x0b3e328455c4059eeb9e3f84b5543f74e24e7e1b",
  "quoteCurrency": "0x4200000000000000000000000000000000000006",
  "from": "2025-02-01T05:03:08.228Z",
  "till": "2025-02-02T05:03:08.228Z",
}

Similar queries