OHLC by intervals for dexrabbit
Returns one DEX trade by token on Polygon, where side currency smart contract is 0x0d50…1270, currency smart contract is 0x2791…4174 and currency smart contract is 0x0d50…1270, sorted by block time: chain ID, block time, sum of trade amount, trade price, side currency symbol, currency symbol, count and 2 more fields.
What it returns
- chain ID
- block time
- sum of trade amount
- trade price
- side currency symbol
- currency symbol
- count
- currency name
- smart contract
Filters
- side currency smart contract is 0x0d50…1270
- currency smart contract is 0x2791…4174
- currency smart contract is 0x0d50…1270
- block date since 2024-03-17
- block date till 2024-06-18
- trade price is above 0
The query
query ($network: evm_network, $interval: Int, $from: String, $till: String, $baseCurrency: String, $quoteCurrency: String) {
EVM(network: $network, dataset: combined) {
DEXTradeByTokens(
orderBy: {ascendingByField: "Block_Time"}
where: {Trade: {Side: {Currency: {SmartContract: {is: $baseCurrency}, Symbol: {}}}, Currency: {SmartContract: {is: $quoteCurrency}, Symbol: {}}, Price: {gt: 0}}, Block: {Date: {since: $from, till: $till}}}
) {
ChainId
Block {
Time(interval: {in: minutes, count: $interval})
}
volume: sum(of: Trade_Amount)
Trade {
high: Price(maximum: Trade_Price)
low: Price(minimum: Trade_Price)
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
Side {
Currency {
Symbol
}
}
Currency {
Symbol
}
}
count
}
token1_info: Transfers(
where: {Transfer: {Currency: {SmartContract: {is: $baseCurrency}}}}
limit: {count: 1}
) {
Transfer {
Currency {
Name
SmartContract
Symbol
}
}
}
token2_info: Transfers(
where: {Transfer: {Currency: {SmartContract: {is: $quoteCurrency}}}}
limit: {count: 1}
) {
Transfer {
Currency {
Name
SmartContract
Symbol
}
}
}
}
}
Variables
{
"network": "matic",
"baseCurrency": "0x0d500b1d8e8ef31e21c99d1db9a6444d3adf1270",
"quoteCurrency": "0x2791bca1f2de4661ed88a30c99a7a9449aa84174",
"limit": "20",
"interval": 15,
"from": "2024-03-17",
"till": "2024-06-18"
}
Similar queries
- polymarket trades api for specific asset id · Polygon · DEXTradeByTokens
- polymarket trades · Polygon · DEXTradeByTokens
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- UniversalSearch EVM · Ethereum · DEXTradeByTokens
- top assets on polymarket · Polygon · DEXTradeByTokens