jake missing dates

Returns 500 DEX trades by token on Ethereum, where currency smart contract is 0x6982…1933, side currency smart contract is 0xdAC1…1ec7 and block date after 2023-04-01, sorted by block testfield: block time, sum of trade amount, trade price and count.

By Divyasshree · saved 17 September 2024 · run 6 times · Bitquery API v2

What it returns

Filters

The query

{
  EVM(network: eth, dataset: combined) {
    DEXTradeByTokens(
      orderBy: {ascendingByField: "Block_testfield"}
      where: {Trade: {Currency: {SmartContract: {is: "0x6982508145454ce325ddbe47a25d4ec3d2311933"}}, Side: {Currency: {SmartContract: {is: "0xdAC17F958D2ee523a2206206994597C13D831ec7"}}}}, Block: {Date: {after: "2023-04-01", before: "2023-08-01"}}}
      limit: {count: 500, offset: 0}
    ) {
      Block {
        testfield: Time(interval: {in: days, count: 1})
      }
      volume: sum(of: Trade_Amount)
      Trade {
        high: Price(maximum: Trade_Price)
        low: Price(minimum: Trade_Price)
        open: Price(minimum: Block_Number)
        close: Price(maximum: Block_Number)
      }
      count
    }
  }
}

Similar queries