Pancakeswap V2 on BSC

Returns DEX trades on BNB Chain, where DEX smart contract is 0xe761…a63c, 0x8b0f…ca64 or 8 more, DEX protocol name is pancake_swap_v2 and block time since 2025-02-05: 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 5 February 2025 · run 80 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": "2025-02-05T10:51:31.046Z",
		"network":            "bsc",
		"protocol":           "pancake_swap_v2",
		"smartContracts":     [
        "0xe7617ffc8bce8d91d7648cb426f755c42c9aa63c",
        "0x8b0fa44dd7204a6a4c557d62dc084f67fdd6ca64",
        "0xc19956eca8a3333671490ef6d6d4329df049dddd",
        "0xfd9891af26664f274af63cbbae810fd36422052e",
        "0xe7f1c36ae52cfc4913407ee49751e396626be5cf",
        "0x7f4c408326b8a317f283b8611ffb5762ddf84893",
        "0x1209072ee4a1ac87b27705e6fb5032bcfbb065f7",
        "0xd9fbd7281959cdac4d16aeb7dadb499c7c07cfa7",
        "0xde655c98a2e761d7d923faf7e26575362621e98a",
        "0xab1e062ab03b11ff7dd943c50b9aa2bf9933c1f3"
    ]
}

Similar queries