bsc token ohlcv
Returns the latest 180 DEX trades by token on BNB Chain, where currency smart contract is 0x144c…4444, side type is buy and side type is sell: block time, sum of trade amount, sum of trade side amount in USD, trade price, price in USD, currency name, currency symbol and 3 more fields.
What it returns
- block time
- sum of trade amount
- sum of trade side amount in USD
- trade price
- price in USD
- currency name
- currency symbol
- smart contract
- count
- trade amount
Filters
- currency smart contract is 0x144c…4444
- side type is buy
- side type is sell
The query
{
EVM(dataset: archive, network: bsc) {
buy: DEXTradeByTokens(
orderBy: {descendingByField: "Block_Timefield"}
where: {Trade: {Currency: {SmartContract:
{is: "0x144c7cb5f89aeb1d5c67c89a31fe18dac8004444"}},
Side: {Type: {is: buy}}}, Block: {Time: {since_relative: {months_ago: 6}}}}
limit: {count: 180}
) {
Block {
Timefield: Time(interval: {in: minutes, count: 1})
}
volume: sum(of: Trade_Amount)
volumeUSD: sum(of: Trade_Side_AmountInUSD, selectWhere: {gt: "0"})
Trade {
high: Price(maximum: Trade_Price)
low: Price(minimum: Trade_Price)
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
highUSD: PriceInUSD(maximum: Trade_PriceInUSD)
lowUSD: PriceInUSD(minimum: Trade_PriceInUSD)
openUSD: PriceInUSD(minimum: Block_Number)
closeUSD: PriceInUSD(maximum: Block_Number)
Currency {
Name
Symbol
SmartContract
}
}
count
tx: count(distinct: Transaction_Hash)
c: count(distinct: Transaction_From)
}
sell: DEXTradeByTokens(
orderBy: {descendingByField: "Block_Timefield"}
where: {Trade: {Currency: {SmartContract:
{is: "0x144c7cb5f89aeb1d5c67c89a31fe18dac8004444"}}, Side: {Type: {is: sell}}}, Block: {Time: {since_relative: {months_ago: 6}}}}
limit: {count: 180}
) {
Block {
Timefield: Time(interval: {in: minutes, count: 1})
}
volume: sum(of: Trade_Amount)
volumeUSD: sum(of: Trade_Side_AmountInUSD, selectWhere: {gt: "0"})
Trade {
max:Amount(maximum:Trade_Amount)
high: Price(maximum: Trade_Price)
low: Price(minimum: Trade_Price)
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
highUSD: PriceInUSD(maximum: Trade_PriceInUSD)
lowUSD: PriceInUSD(minimum: Trade_PriceInUSD)
openUSD: PriceInUSD(minimum: Block_Number)
closeUSD: PriceInUSD(maximum: Block_Number)
Currency {
Name
Symbol
SmartContract
}
}
count
tx: count(distinct: Transaction_Hash)
c: count(distinct: Transaction_From)
}
}
}
Similar queries
- bStocks 3am: QQQB 30-day DEX volume · BNB Chain · DEXTradeByTokens
- bStocks 3am: tokenized Tesla 30-day volume · BNB Chain · DEXTradeByTokens
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- KTI_primeiros_trades · BNB Chain · DEXTradeByTokens
- 1st trade of token on various dex/router · BNB Chain · DEXTradeByTokens