support ExchangePipeline query

Returns DEX trades on Ethereum, where DEX smart contract is 0x0d4a…1852, DEX protocol name is uniswap_v2 and block time since 2024-06-03: 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 28 June 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-06-03T10:51:31.046Z",
		"network":            "eth",
		"protocol":           "uniswap_v2",
		"smartContracts":     [
      "0x0d4a11d5eeaac28ec3f61d100daf4d40471f1852"
    ]
}

Similar queries