[V2] Transactions (debug)
Returns 1000 DEX trades on BNB Chain, where buy currency smart contract is 0xbb4c…095c, sell currency smart contract is 0xe9e7…7d56 and DEX protocol name is pancake_swap_v3, sorted by block number: buy amount, buy amount in USD, buy decimals, buy currency symbol, buy smart contract, buy buyer, sell amount and 15 more fields.
What it returns
- buy amount
- buy amount in USD
- buy decimals
- buy currency symbol
- buy smart contract
- buy buyer
- sell amount
- sell amount in USD
- sell decimals
- sell currency name
- sell smart contract
- sell currency symbol
- sell seller
- protocol family
- protocol name
- smart contract
- block number
- block time
- block hash
- transaction hash
- transaction index
- success
Filters
- buy currency smart contract is 0xbb4c…095c
- sell currency smart contract is 0xe9e7…7d56
- DEX protocol name is pancake_swap_v3
- block time since 2024-07-26
- block time before 2024-07-26
The query
{
EVM(dataset: combined, network: bsc) {
DEXTrades(
where: {Block: {Time: {since: "2024-07-26T09:35:00Z", before: "2024-07-26T09:40:00Z"}}, Trade: {Buy: {Currency: {SmartContract: {is: "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c"}}}, Sell: {Currency: {SmartContract: {is: "0xe9e7cea3dedca5984780bafc599bd69add087d56"}}}, Dex: {ProtocolName: {is: "pancake_swap_v3"}}}}
limit: {count: 1000}
orderBy: {ascending: Block_Number}
) {
Trade {
Buy {
Amount
AmountInUSD
Currency {
Decimals
Symbol
SmartContract
}
Buyer
}
Sell {
Amount
AmountInUSD
Currency {
Decimals
Name
SmartContract
Symbol
}
Seller
}
Dex {
ProtocolFamily
ProtocolName
SmartContract
}
}
Block {
Number
Time
Hash
}
Transaction {
Hash
Index
}
TransactionStatus {
Success
}
}
}
}
Variables
{
"from": "2022-07-20T01:36:32Z",
"to": "2022-07-20T01:37:32Z"
}
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