pool_creation_query

Returns 100 DEX trades on Ethereum, where buy currency smart contract is 0xdac1…1ec7, block date since 2018-08-03 and block date till 2020-08-03, sorted by block date: smart contract and block date.

By Omkar_BQ · saved 25 September 2024 · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: eth, dataset: archive) {
    DEXTrades(
      where: {Trade: {Buy: {Currency: {SmartContract: {is: "0xdac17f958d2ee523a2206206994597c13d831ec7"}}}}, Block: {Date: {since: "2018-08-03", till: "2020-08-03"}}}
      limitBy: {by: Trade_Dex_SmartContract, count: 1}
      orderBy: {ascendingByField: "Block_Date"}
      limit: {count: 100}
    ) {
      Trade {
        Dex {
          SmartContract
        }
      }
      Block {
        Date
      }
    }
  }
}

Similar queries