WEPE Historical Data
Returns the latest 10 DEX trades by token on Ethereum, where currency smart contract is 0xccb3…bf10, side currency smart contract is 0xc02a…6cc2 and block time after 2025-01-01: block time, price in USD, currency name, currency symbol, smart contract, side currency name, side currency symbol and 5 more fields.
What it returns
- block time
- price in USD
- currency name
- currency symbol
- smart contract
- side currency name
- side currency symbol
- side smart contract
- count
- unique of trade seller
- unique of trade buyer
- sum of trade amount in USD
Filters
- currency smart contract is 0xccb3…bf10
- side currency smart contract is 0xc02a…6cc2
- block time after 2025-01-01
The query
{
EVM(network: eth, dataset: realtime) {
Price_Data: DEXTradeByTokens(
limit: {count: 10}
where: {Block: {Time: {after: "2025-01-01T00:00:00Z"}}, Trade: {Currency: {SmartContract: {is: "0xccb365d2e11ae4d6d74715c680f56cf58bf4bf10"}}, Side: {Currency: {SmartContract: {is: "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"}}}}}
orderBy: {descendingByField: "Block_Time"}
) {
Block {
Time(interval: {count: 5, in: minutes})
}
Trade {
Price_High: PriceInUSD(maximum: Trade_PriceInUSD)
Price_Low: PriceInUSD(minimum: Trade_PriceInUSD)
Price_Open: PriceInUSD(minimum: Block_Number)
Price_Close: PriceInUSD(maximum: Block_Number)
Currency_From: Currency {
Name
Symbol
SmartContract
}
Currency_To: Side {
Currency {
Name
Symbol
SmartContract
}
}
}
Total_Trades: count
Total_Buys: count(if: {Trade: {Side: {Type: {is: sell}}}})
Total_Sells: count(if: {Trade: {Side: {Type: {is: buy}}}})
Total_Sellers: uniq(of: Trade_Seller)
Total_Buyers: uniq(of: Trade_Buyer)
Volume: sum(of: Trade_AmountInUSD)
}
}
}
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