jake missing dates
Returns 500 DEX trades by token on Ethereum, where currency smart contract is 0x6982…1933, side currency smart contract is 0xdAC1…1ec7 and block date after 2023-04-01, sorted by block testfield: block time, sum of trade amount, trade price and count.
What it returns
- block time
- sum of trade amount
- trade price
- count
Filters
- currency smart contract is 0x6982…1933
- side currency smart contract is 0xdAC1…1ec7
- block date after 2023-04-01
- block date before 2023-08-01
The query
{
EVM(network: eth, dataset: combined) {
DEXTradeByTokens(
orderBy: {ascendingByField: "Block_testfield"}
where: {Trade: {Currency: {SmartContract: {is: "0x6982508145454ce325ddbe47a25d4ec3d2311933"}}, Side: {Currency: {SmartContract: {is: "0xdAC17F958D2ee523a2206206994597C13D831ec7"}}}}, Block: {Date: {after: "2023-04-01", before: "2023-08-01"}}}
limit: {count: 500, offset: 0}
) {
Block {
testfield: Time(interval: {in: days, count: 1})
}
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)
}
count
}
}
}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens