query bsc pools

Returns the latest 10000 arguments on Ethereum and BNB Chain, where smart contract address is 0xcA14…0c73 and smart contract event is PairCreated: block height, timestamp time, index and any of argument value.

By EricV · saved 26 November 2024 · run 1 time · Bitquery API v1

What it returns

Filters

The query

query Pools($address: [String!]!, $startDate: ISO8601DateTime!, $endDate: ISO8601DateTime!) {
  ethereum(network: bsc) {
    arguments(
      options: {desc: ["block.height", "index"], limit: 10000, offset: 0}
      date: {between: [$startDate, $endDate]}
      smartContractAddress: {in: $address}
      smartContractEvent: {is: "PairCreated"}
    ) {
      block {
        height
        timestamp {
          time(format: "%Y-%m-%d %H:%M:%S")
        }
      }
      index
      pair: any(of: argument_value, argument: {is: "pair"})
      token0: any(of: argument_value, argument: {is: "token0"})
      token0Name: any(of: argument_value, argument: {is: "token0"}, as: token_name)
      token1: any(of: argument_value, argument: {is: "token1"})
      token1Name: any(of: argument_value, argument: {is: "token1"}, as: token_name)
    }
  }
}

Variables

{
  "address": "0xcA143Ce32Fe78f1f7019d7d551a6402fC5350c73",
  "startDate": "2024-01-01", 
  "endDate": "2024-01-01"
}

Similar queries