new_v2_ohlcv
Returns 100 DEX trades on BNB Chain, where DEX owner address is 0xca14…0c73, 0x0bfb…1865 or 1 more, buy currency smart contract is 0xbb4c…095c, 0x55d3…7955 or 1 more and sell currency smart contract is 0xbb4c…095c, 0x55d3…7955 or 1 more, sorted by count, highest first: chain ID, buy smart contract, buy currency symbol, buy price in USD, sell price in USD, sell smart contract, sell currency symbol and 2 more fields.
What it returns
- chain ID
- buy smart contract
- buy currency symbol
- buy price in USD
- sell price in USD
- sell smart contract
- sell currency symbol
- count
- block time
Filters
- DEX owner address is 0xca14…0c73, 0x0bfb…1865 or 1 more
- buy currency smart contract is 0xbb4c…095c, 0x55d3…7955 or 1 more
- sell currency smart contract is 0xbb4c…095c, 0x55d3…7955 or 1 more
- block time since 2024-06-01
- block time till 2024-06-03
- buy price in USD is above 1.5
- buy price in USD is below 100
- sell price in USD is above 1
- sell price in USD is below 100
The query
query ($network: evm_network, $limit: Int, $from: DateTime, $till: DateTime, $quoteCurrencies: [String!], $exchangeAddresses: [String!]) {
EVM(network: $network, dataset: combined) {
DEXTrades(
limit: {count: $limit}
limitBy: {by: [Trade_Sell_Currency_SmartContract, Trade_Buy_Currency_SmartContract]}
orderBy: {descendingByField: "count"}
where: {Block: {Time: {since: $from, till: $till}}, Trade: {Dex: {OwnerAddress: {in: $exchangeAddresses}}, Buy: {PriceInUSD: {gt: 1.5, lt: 100}, Currency: {SmartContract: {in: $quoteCurrencies}, Name: {startsWith: ""}}}, Sell: {Currency: {SmartContract: {in: $quoteCurrencies}}, PriceInUSD: {gt: 1, lt: 100}}}}
) {
ChainId
Trade {
Buy {
Currency {
SmartContract
Symbol
}
PriceInUSD
}
Sell {
PriceInUSD
Currency {
SmartContract
Symbol
}
}
}
count
Block {
Time
}
}
}
}
Variables
{
"network": "bsc",
"limit": 100,
"from": "2024-06-01T10:20:30Z",
"till": "2024-06-03T10:20:30Z",
"quoteCurrencies": ["0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c", "0x55d398326f99059ff775485246999027b3197955", "0xe9e7cea3dedca5984780bafc599bd69add087d56"],
"exchangeAddresses": ["0xca143ce32fe78f1f7019d7d551a6402fc5350c73", "0x0bfbcf9fa4f9c56b0f40a671ad40e0805a091865", "0xdb1d10011ad0ff90774d0c6bb92e5c5c8b4461f7"]
}
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