Too many markets for balancer v2

Returns DEX trades on Ethereum, where DEX smart contract is 0xa821…5e43, 0xba12…f2c8 or 1 more, DEX protocol name is balancer_v2 and block time since 2024-11-24: buy currency symbol, buy smart contract, buy currency name, buy price, sell currency symbol, sell smart contract, sell currency name and 7 more fields.

By Coinranking · saved 25 November 2024 · run 3 times · Bitquery API v2

What it returns

Filters

The query

query fetchBulkTickers(
  $network: evm_network!
  $protocol: String!
  $twentyFourHoursAgo: DateTime
  $smartContracts: [String!]!
) {
  EVM(dataset: realtime, network: $network) {
    DEXTrades(
      where: {
        Trade: {
          Dex: {
            ProtocolName: { is: $protocol }
            SmartContract: { in: $smartContracts }
          }
        }
        Block: { Time: { since: $twentyFourHoursAgo } }
      }
    ) {
      Trade {
        Buy {
          Currency {
            Symbol
            SmartContract
            Name
          }
          High: Price(maximum: Trade_Buy_Price)
          Low: Price(minimum: Trade_Buy_Price)
          Open: Price(minimum: Block_Number)
          Close: Price(maximum: Block_Number)
        }
        Sell {
          Currency {
            Symbol
            SmartContract
            Name
          }
          High: Price(maximum: Trade_Sell_Price)
          Low: Price(minimum: Trade_Sell_Price)
          Open: Price(minimum: Block_Number)
          Close: Price(maximum: Block_Number)
        }
        Dex {
          ProtocolName
          SmartContract
        }
      }
      VolumeBuy: sum(of: Trade_Buy_Amount)
      VolumeSell: sum(of: Trade_Sell_Amount)
      Block {
        LastTradeTime: Time(maximum: Block_Time)
        FirstTradeTime: Time(minimum: Block_Time)
        LastTradeBlock: Number(maximum: Block_Number)
        FirstTradeBlock: Number(minimum: Block_Number)
      }
    }
  }
}

Variables

{
  	"twentyFourHoursAgo": "2024-11-24T10:51:31.046Z",
		"network":            "eth",
		"protocol":           "balancer_v2",
    "smartContracts": [
      "0xa8210885430aaa333c9f0d66ab5d0c312bed5e43",
"0xba12222222228d8ba445958a75a0704d566bf2c8",
"0xd315a9c38ec871068fec378e4ce78af528c76293"
    ]
}

Similar queries