price of the token against other than BNB, BUSD in different pools on PankcakeSwap v2
Returns 10 DEX trades on BNB Chain, where buy currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more, sell currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more and DEX owner address is 0xca14…0c73: buy amount, buy buyer, buy currency name, buy smart contract, buy currency symbol, buy price, buy price in USD and 10 more fields.
What it returns
- buy amount
- buy buyer
- buy currency name
- buy smart contract
- buy currency symbol
- buy price
- buy price in USD
- buy seller
- sell amount
- sell buyer
- sell price
- sell price in USD
- sell seller
- sell currency name
- sell smart contract
- owner address
- smart contract
Filters
- buy currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more
- sell currency smart contract is not 0xbb4c…095c, 0x55d3…7955 or 1 more
- DEX owner address is 0xca14…0c73
- block date is 2024-05-27
The query
query MyQuery {
EVM(dataset: combined, network: bsc) {
DEXTrades(
where: {Block: {Date: {is: "2024-05-27"}}, Trade: {Buy:
{Currency:
{SmartContract:
{notIn:
["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c",
"0x55d398326f99059ff775485246999027b3197955",
"0xe9e7cea3dedca5984780bafc599bd69add087d56"]}}},
Sell: {Currency:
{SmartContract:
{notIn: ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", "0x55d398326f99059ff775485246999027b3197955", "0xe9e7cea3dedca5984780bafc599bd69add087d56"]}}}, Dex: {OwnerAddress: {is: "0xca143ce32fe78f1f7019d7d551a6402fc5350c73"}}},
any: [{Trade: {Buy:
{Currency: {SmartContract:
{is: "0xba2ae424d960c26247dd6c32edc70b295c744c43"}}}}}, {Trade: {Sell: {Currency: {SmartContract: {is: "0xba2ae424d960c26247dd6c32edc70b295c744c43"}}}}}]}
limitBy: {by: Trade_Dex_Pair_Name}
limit: {count: 10}
) {
Trade {
Buy {
Amount
Buyer
Currency {
Name
SmartContract
Symbol
}
Price
PriceInUSD
Seller
}
Sell {
Amount
Buyer
Price
PriceInUSD
Seller
Currency {
Name
SmartContract
}
}
Dex {
Exchange_Address: OwnerAddress
Pool_Address: SmartContract
}
}
}
}
}
Similar queries
- Latest DODO DEX swaps on BSC · BNB Chain · DEXTrades
- Top DODO liquidity pools by 24h volume on BSC · BNB Chain · DEXTrades
- trades · Ethereum · DEXTrades
- metric_v1_bsc · BNB Chain · DEXTrades
- bsc_tessera · BNB Chain · DEXTrades