getTokenPriceForDate
Returns the latest 10 DEX trades by token on Base, where currency smart contract is 0x4200…0006, block time since 2024-10-20 and block time till 2024-10-21: average of trade price in USD.
What it returns
- average of trade price in USD
Filters
- currency smart contract is 0x4200…0006
- block time since 2024-10-20
- block time till 2024-10-21
- trade price in USD is above 0
- trade amount in USD is above 0.001
The query
query getTokenPriceForDate(
$dataset: dataset_arg_enum!,
$network: evm_network!,
$tokenAddress: String!,
$since: DateTime!,
$till: DateTime!
) {
EVM(dataset: $dataset, network: $network) {
DEXTradeByTokens(
# Get the last 10 trades
limit: { count: 10 }
orderBy: { descending: Block_Time }
where: {Trade: {PriceInUSD: { gt: 0 }, Currency: {SmartContract: {is: $tokenAddress}}, AmountInUSD: {gt: "0.001"}}, Block: {Time: {since: $since, till: $till}}}
) {
PriceInUSD: average(of: Trade_PriceInUSD)
}
}
}
Variables
{
"dataset": "combined",
"network": "base",
"tokenAddress": "0x4200000000000000000000000000000000000006",
"since": "2024-10-20T15:00:00Z",
"till": "2024-10-21T15:00:00Z"
}
Similar queries
- Coinbase stock tokens: DEX trading on Base, Sep 5 to Oct 4 2026 · Base · DEXTradeByTokens
- Coinbase stock tokens: DEX trading on Base in August 2026 · Base · DEXTradeByTokens
- optimized query to get pools data · Ethereum · DEXTradeByTokens
- AfricaCryptoChainx · Ethereum · DEXTradeByTokens
- top pools of a token · Base · DEXTradeByTokens