OHLC bsc
Returns DEX trades by token on BNB Chain, where side currency smart contract is 0xbb4c…095c, currency smart contract is 0x55d3…7955 and block time since 2025-03-03, sorted by block time: block time, quantile of trade price in USD, average of trade price in USD, sum of trade side amount in USD, average of trade price and count.
What it returns
- block time
- quantile of trade price in USD
- average of trade price in USD
- sum of trade side amount in USD
- average of trade price
- count
Filters
- side currency smart contract is 0xbb4c…095c
- currency smart contract is 0x55d3…7955
- block time since 2025-03-03
- side amount is above 0
The query
query tradingViewPairs($network: evm_network, $dataset: dataset_arg_enum, $interval: Int, $token: String, $base: String, $time_ago: DateTime) {
EVM(network: $network, dataset: $dataset) {
DEXTradeByTokens(
orderBy: {ascendingByField: "Block_Time"}
where: {TransactionStatus: {Success: true}, Trade: {Side: {Amount: {gt: "0"}, Currency: {SmartContract: {is: $token}}}, Currency: {SmartContract: {is: $base}}, Success: true}, Block: {Time: {since: $time_ago}}}
) {
Block {
Time(interval: {count: $interval, in: seconds})
}
min: quantile(of: Trade_PriceInUSD, level: 0.1)
max: quantile(of: Trade_PriceInUSD, level: 0.9)
close: average(of: Trade_PriceInUSD)
open: average(of: Trade_PriceInUSD)
volume: sum(of: Trade_Side_AmountInUSD)
aa: average(of: Trade_Price)
count
}
}
}
Variables
{
"network": "bsc",
"base": "0x55d398326f99059ff775485246999027b3197955",
"token": "0xbb4cdb9cbd36b01bd1cbaebf2de08d9173bc095c",
"time_ago": "2025-03-03T11:08:30Z",
"dataset": "archive",
"interval": 300
}
Similar queries
- bStocks 3am: QQQB 30-day DEX volume · BNB Chain · DEXTradeByTokens
- bStocks 3am: tokenized Tesla 30-day volume · BNB Chain · DEXTradeByTokens
- bsc token ohlcv · BNB Chain · DEXTradeByTokens
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- KTI_primeiros_trades · BNB Chain · DEXTradeByTokens